Skip to main content

Create a PostgreSQL cluster for 1C

Last update:

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

Create cluster

  1. In the control panel, on the top menu click Products and select Managed Databases.

  2. Click Create cluster.

  3. Enter a cluster name.

  4. Select a location. Once created, the location cannot be changed.

  5. Select a DBMS — PostgreSQL 1C.

  6. Select a PostgreSQL version. Once created, the version cannot be changed.

  7. Select a configuration line and specify the number of vCPUs, RAM size, and disk size.

    The configuration depends on the number of users working with 1C simultaneously and the size of the information base. For example, if up to 50 users work in 1C simultaneously, a configuration with 4 vCPUs and 16 GB of RAM will be suitable. If there are more than 50 users, we recommend a configuration with 8 vCPUs and 32 GB of RAM.

    After creating the cluster, you can change the node configuration — scale the cluster.

  8. Optional: to set up cluster fault tolerance, in the Fault tolerance block, specify the number of nodes in the cluster. The first node is the master node, the rest are replicas. For a multi-node cluster, an SLA applies — we guarantee 99.95% write availability and 99.99% read availability.

  9. Optional: to access cluster logs, enable logging. Logging uses some of the cluster's computational resources.

    9.1.Select the Collect technical cluster logs to a log service checkbox.

    9.2.Select a log group or create a new one.

    9.3.If you selected a new group, enter its name.

  10. Select or create a subnet:

    • a private subnet — a subnet with no internet access. You can connect a static public IP address;
    • or a public subnet — all addresses in the public subnet are accessible from the internet.

    Addresses are assigned to each node in the cluster. Ensure the number of addresses in the network is at least the number of nodes in the cluster. If you plan to increase the number of replicas after creating the cluster, choose a subnet that has a pool of free addresses. Once created, the subnet cannot be changed.

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

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

    • if you have selected an existing private subnet — select the Public access to cluster nodes checkbox, and then the checkbox for the node to which you want to provide public access. The private subnet must meet the requirements;
    • if you are creating a new private subnet — connect a public IP address after creating the cluster.

  12. Optional: select security groups to filter incoming and outgoing cluster traffic. If the Security block is missing, traffic filtering (port security) is disabled in the cluster network. With traffic filtering disabled, all traffic will be allowed.

  13. Optional: to view the default DBMS settings or change them, click Change. We recommend changing settings values only when necessary — incorrectly chosen values can reduce cluster performance.

  14. Check the cluster price.

  15. Click Create cluster. The cluster will be ready for use when it reaches 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 Managed Databases.
  3. Open the Active tab.
  4. Open the cluster page → Databases tab.
  5. Click Create database.
  6. Enter a database name.
  7. Select a database owner user.
  8. Enter the character set locale (LC_CTYPE) — it is responsible for character classification and case conversion. You cannot change the locale after the database has been created. See more about locales in the PostgreSQL documentation.
  9. Enter the collation locale (LC_COLLATE) — it determines the settings for comparing strings and characters, and also influences sorting. You cannot change the locale after the database has been created.
  10. Click Create.

Connect the database to a 1C server

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

  • Secure connection — Disabled;
  • DBMS type — PostgreSQL;
  • Database server — <master-node DNS address> port:5432;
  • Database name — Name of the created database;
  • Database user — Username;
  • User password — Password.