PostgreSQL for 1C

Versions and configurations

Available versions of PostgreSQL for 1C, fixed and arbitrary cluster node configurations

Local disks

Features of local disks

Create a cluster

How to create a PostgreSQL cluster for 1C and connect the database to the 1C server

PostgreSQL settings for 1C

How to change PostgreSQL settings for 1C

PostgreSQL Extensions for 1C

List of PostgreSQL extensions that we connect to work with 1C:Enterprise

Connection Pooler

The role of the connection pooler and the connection pooler that PostgreSQL uses for 1C

User management

How to create a user, change his password, configure database access and work with privileges

Connect to the cluster

How to connect to PostgreSQL cluster for 1C with or without SSL certificate in console and from different programming languages

Monitoring

How to track the status of nodes, databases and cluster and how to export metrics in Prometheus format

Scale up the cluster

How to change the configuration of a node cluster

Backup

Backup schedule, backup retention period and how to restore the cluster

Cluster fault tolerance

The role of master node and replicas in a cluster, how to change the number of replicas

Configure network access to the cluster

How to restrict access to the cluster from certain addresses for security purposes

Public IP address

How to connect a public IP address to a PostgreSQL cluster node for 1C

Create a network with a dedicated server

How to create a network with a dedicated server

Migration to cloud databases

How to migrate PostgreSQL database to cloud databases