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
Settings
How to change PostgreSQL settings for 1C
Extensions
List of PostgreSQL extensions that we plug in to work with 1C:Enterprise
Connection Pooler
The role of a 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 cluster, nodes and databases
How to monitor nodes, databases and cluster status and how to export metrics in Prometheus format
Cluster Logs
How to enable cluster logging, how to get logs and disable cluster logging
Scale a cluster
How to change node cluster configuration
Backups
Backup schedule, backup retention period and how to restore a cluster from backup
Cluster Fault Tolerance
The 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 a cluster
How to define a list of allowed IP addresses, basic information about security groups in a database cluster and how to assign a security group
Public IP address
How to connect a public IP address to a PostgreSQL cluster node for 1C
Link a cluster to a dedicated server
How to link a cluster to a dedicated server
Migration to cloud databases
How to migrate PostgreSQL database to cloud databases