PostgreSQL for 1C
Versions and configurations
Available PostgreSQL versions for 1C, fixed and arbitrary cluster node configurations
Disks
Basic information about disks used in PostgreSQL database cluster for 1C
Create a cluster
How to create a PostgreSQL cluster for 1C and connect a database to a 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 a connection pooler and a connection pooler that uses PostgreSQL for 1C
User Management
How to create a user, change their password, set up database access and work with privileges
Connect to cluster
How to connect to PostgreSQL cluster for 1C with or without SSL certificate in console and from different programming languages
Monitoring
How to monitor node, database and cluster health and how to export metrics in Prometheus format
Scale the cluster
How to change the cluster node configuration
Backups
Backup schedule, backup retention period and how to restore a cluster
Cluster fault tolerance
Role of master node and replicas in a cluster, placement of nodes 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
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 a PostgreSQL Database to Cloud Databases