Create a PostgreSQL cluster for 1C

Last update: October 05 2026Open in Markdown

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

Create cluster

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

2. Click Create cluster.

3. Enter the cluster name.

4. Select a location. The location cannot be changed after creation.

5. Select the database engine — PostgreSQL 1C.

6. Select a PostgreSQL version. The version cannot be changed after creation.

7. Fill in the following blocks:

   • Node configuration;
   • optional: Fault tolerance;
   • optional: Logging;
   • Network;
   • optional: Security;
   • optional: DBMS settings.

8. Check the cluster price.

9. Click Create cluster.

Node configuration

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

1. Select a configuration line.

2. If you selected a custom configuration line, select a disk type, specify the number of vCPUs, RAM size, and disk size.

3. If you selected a line with fixed configurations, select a configuration.

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

Optional: Fault tolerance

To ensure cluster fault tolerance, add replicas — exact copies of the master node. To do this, specify the number of nodes in the cluster. The first node is the master node, the rest are replicas. Replicas are read-only (SELECT).

For multi-node clusters, the SLA applies — we guarantee 99.95% write availability and 99.99% read availability.

Optional: Logging

To access cluster logs, enable logging. Logging uses part of the cluster's compute resources.

1. Select the Collect technical cluster logs into the log service checkbox.

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

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

Network

You can connect a PostgreSQL for 1C cluster:

• to a private subnet — without internet access. You can connect a public floating IP address for internet access. A separate address is connected to each cluster node;

• or to a public subnet — in which all addresses are accessible from the internet.

You can create a new subnet or add the cluster to an existing one.

Private subnet

1. To add a cluster to an existing private subnet:

   1.1. In the Subnet field, select an existing subnet. The number of addresses in the selected subnet must be no less than the number of nodes in the cluster. The subnet cannot be changed after creation.

   1.2. Optional: to make the cluster nodes accessible from the internet, in the Public access to cluster nodes block, select the checkbox for the node to which you want to attach a public floating IP address. The Public access to cluster nodes block is available if the private subnet meets the requirements. If the subnet does not meet the requirements, you can connect a public floating IP address after creating the cluster.

2. To create a new private subnet:

   2.1. In the Subnet field, select New private subnet. The number of addresses in the subnet must be no less than the number of nodes in the cluster. The subnet cannot be changed after creation.

   2.2. Optional: change the subnet CIDR.

   2.3. Optional: change the network where the subnet will be created — you can select an existing network or create a new one. You cannot change the network after creating the cluster.

Public subnet

1. To add a cluster to an existing public subnet, in the Subnet field, select an existing subnet. The number of addresses in the selected subnet must be no less than the number of nodes in the cluster. The subnet cannot be changed after creation.

2. To create a new public subnet:

   2.1. In the Subnet field, select New public subnet. The number of addresses in the subnet must be no less than the number of nodes in the cluster. The subnet cannot be changed after creation.

   2.2. Optional: change the subnet size.

Optional: Security

Select security groups to filter inbound and outbound cluster traffic.

If the Security block is missing, traffic filtering (port security) is disabled in the cluster network. If traffic filtering is disabled, all traffic will be allowed.

Optional: DBMS settings

To view the default DBMS settings or change them, click Edit. We recommend changing setting values only if necessary — incorrectly configured values can lead to cluster failure or degraded performance.

Create a database

1. Создайте пользователя — the database must have an owner user.
2. In the control panel, in the top menu, click Products and select Cloud Databases.
3. Open the Active tab.
4. Open the cluster page → Databases tab.
5. Click Create database.
6. Enter a database name.
7. Select the database owner user.
8. Enter the character set locale (LC_CTYPE) — it determines character classification and case sensitivity. The locale cannot be changed after the database is created. Learn more about locales in the PostgreSQL documentation.
9. Enter the collation locale (LC_COLLATE) — it determines string and character comparison settings and affects sorting. The locale cannot be changed after the database is created.
10. Click Create.

Connect database to 1C server

To connect a PostgreSQL database as a 1C infobase, use the following parameters in the infobase addition form 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.