Skip to main content
Create PostgreSQL cluster for 1C
Last update:

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. В control panels go to Cloud platform → Databases.

  2. Click Create a cluster.

  3. Enter the name of the cluster.

  4. Select region.

  5. Select pool.

  6. Select PostgreSQL version for 1C.

  7. Select node configuration:

    • fixed — configurations with different ratio of vCPU, RAM and local disk;
    • arbitrary — free choice of the ratio of resources.

    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.

  8. For a fixed configuration, select configuration line:

    • Standard;
    • CPU;
    • Memory;
    • HighFreq;
    • Dedicated.

  9. Optional: check the checkbox Add replicas and specify the number of replicas. Replicas increase the fault tolerance of the cluster.

  10. Select the type of subnet to which the cluster will be connected:

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

  11. Select or create a subnet.

    Addresses are assigned to each node in the cluster. Make sure that the number of addresses in the subnet 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 address list from which access to the database cluster will be allowed.

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

    • If you have selected an existing private subnet, check the box. Public access to cluster nodesand then check the checkbox of the node to which you want to grant public access. The private subnet must correspond to demands;
    • if you create a new private subnet — connect a public IP address after the cluster is created.

  13. Optional: change DBMS settings To do this, press Modify. We recommend that you change the settings only when necessary — incorrect values can reduce cluster performance.

  14. Click Create a database cluster.

  15. Create a database.

Create a database⁠

  1. Create a user — the database must have an owner user.
  2. В control panels go to Cloud platform → Databases.
  3. Open the cluster page → tab Databases.
  4. Click Create a database.
  5. Enter the name of the database.
  6. Select the user who owns the database.
  7. Enter the character set locale (LC_CTYPE) — responsible for character classification and case differences. Once the database is created, you cannot change the locale. More information about locales in PostgreSQL documentation.
  8. 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.
  9. 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:

  • The secure connection is Off;
  • The type of DBMS is. PostgreSQL;
  • The database server is. <DNS address of the master node> port:5432;
  • The name of the database is. Name of the created database;
  • The database user is. User Name;
  • The user's password is. Password.