Skip to main content
Create PostgreSQL cluster for 1C

Create PostgreSQL cluster for 1C

In cloud databases, you can create a PostgreSQL cluster customized specifically to work with 1C:Enterprise.

Create a cluster⁠

  1. In the Control panel, on the top menu, click Products and select Cloud Databases.

  2. Click Create Cluster.

  3. Enter the name of the cluster.

  4. Select a region.

  5. Select a pool. Once created, the pool cannot be changed.

  6. Select DBMS — PostgreSQL 1C.

  7. Select the PostgreSQL version. Once created, the version cannot be changed.

  8. Select a line of configurations and specify the number of vCPUs, RAM size, and disk size.

    The choice of configuration depends on the number of users who work with 1C at the same time and the size of the information base. For example, if up to 50 users work with 1C at the same time, a configuration with 4 vCPU and 16 GB RAM is suitable. If there are more than 50 users, we recommend the configuration with 8 vCPU and 32 GB RAM.

    Once the cluster is created, you can change the configuration of nodes — scaling the cluster.

  9. Optional: to configure cluster fault tolerance, specify the number of nodes in the cluster in the Fault Tolerance block. The first node is the master node, the rest are replicas. SLA for a multi-node cluster  — we guarantee 99.95% write availability and 99.99% read availability.

  10. Select or create a subnet:

    • private subnet — a subnet without access from the Internet. You can connect a static public IP address;
    • or public subnet — all addresses on a public subnet are accessible from the Internet.

    Addresses are assigned to each node in the cluster. Make sure that the number of addresses in the network is not less than the number of nodes in the cluster. If you plan to increase the number of replicas after the cluster is created, select a subnet that has a supply of free addresses. Once the cluster is created, the subnet cannot be changed.

    You can restrict the list of addresses from which access to the database cluster will be allowed.

  11. Optional: In a private subnet, you can connect a public IP address to a cluster node:

    • If you selected an existing private subnet — check the Public access to cluster nodes checkbox and then the checkbox of the node to which you want to grant public access. The private subnet must meet the requirements;
    • if you are creating a new private subnet — connect the public IP address after the cluster is created.

  12. Optional: To change the DBMS settings, click Change. We recommend that you change the settings only when necessary — incorrectly selected values may reduce cluster performance.

  13. Check the price of the cluster.

  14. Click Create Cluster. The cluster will be ready for operation when it enters the ACTIVE status.

Create a database⁠

  1. Create a user — The database must have an owner user.
  2. In the Control panel, on the top menu, click Products and select Cloud Databases.
  3. Open the Active tab.
  4. Open the cluster page → Database tab.
  5. Click Create Database.
  6. Enter the name of the database.
  7. Select the user who owns the database.
  8. Enter the character set locale (LC_CTYPE) — responsible for character classification and case differences. Once the database is created, you cannot change the locale. For more information about locales, see PostgreSQL documentation.
  9. Enter sorting locale (LC_COLLATE) — determines the settings for string and character comparison and affects sorting. Once the database is created, the locale cannot be changed.
  10. Click Create.

Connect database to 1C server⁠

To connect a PostgreSQL database as a 1C information base, use the parameters in the form of adding an information base to 1C:Enterprise:

  • Secure Connection — Off;
  • The type of DBMS is PostgreSQL;
  • Database server — \ <DNS address of the master node> port:5432;
  • Database Name — The name of the created database;
  • Database User — User Name;
  • User Password — Password.