Connect to PostgreSQL cluster for 1C

Last update: September 06 2024

Connect to PostgreSQL cluster for 1C

You can connect to the PostgreSQL cloud database cluster for 1C by DNS address, private IP address and public IP address.

We recommend connecting by DNS address because DNS addresses correspond to node roles and lead to the actual IP addresses of the master and replicas. IP addresses correspond to specific nodes. If the master is unavailable, one of the replicas will assume its role, the master's IP address will change, and the IP connection will stop working.

If the cluster is connected to a private subnet and you want to work with it via DNS, connect the cluster subnet to a cloud router with access to the external network. Use the following instructions Set up internet access via cloud router.

If the cluster is connected to a private network and you need to configure access to the node from the Internet, connect a public IP address.

Ports⁠

Use ports to connect to PostgreSQL for 1C:

• 5432 — port to connect directly to the PostgreSQL process for 1C;
• 6432 is the port to connect to the master note.

Ways of connection⁠

• through the psql terminal client;
• through graphical database management tools: pgAdmin or an office suite with ODBC or JDBC support;
• from the program code.

Connection with SSL certificate is available for all methods.

View the address for connection⁠

1. В control panels go to Cloud platform → Databases.
2. Open the Database Cluster page → tab Connection.
3. In the block Addresses for connection check out the address.

Connect to the cluster⁠

1С

To connect a PostgreSQL database for 1C 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 master node> port:<Port>;
• The name of the database is. Name of the created database;
• The database user is. User Name;
• The user's password is. Password.

Bash

psql --host=<host> \
    --port=<port> \
    --user=<database_user_name> \
    --dbname=<database_name> \
    --set=sslmode=verify-ca

Specify:

• <host> — DNS address of the node;
• <port> — connection port;
• <database_user_name> — database user name;
• <database_name> — database name.