PostgreSQL for 1C
Versions and configurations
Available PostgreSQL versions for 1C, fixed and custom cluster node configurations
Volumes
Key information about volumes used in a PostgreSQL for 1C database cluster
Create 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 enable for working with 1C:Enterprise
Connection pooler
The role of the connection pooler and the connection pooler used by PostgreSQL for 1C
Managing users
How to create a user, change their password, configure access to a PostgreSQL for 1C database, and work with privileges
Connect to a cluster
How to connect to a PostgreSQL for 1C cluster with or without an SSL certificate in the console or from various programming languages
Monitoring of cluster, nodes, and databases
How to monitor the status of PostgreSQL cluster nodes, databases for 1C, and how to export metrics in Prometheus format
Cluster logs
How to enable PostgreSQL for 1C cluster logging, how to get logs and disable cluster logging
Using disk space
How disk space is used in a PostgreSQL for 1C cluster and how to clear the disk
Scale a cluster
How to change the configuration of PostgreSQL for 1C cluster nodes
Backups
PostgreSQL cluster backup schedule for 1C, backup retention period, and how to restore a cluster from a backup
Cluster fault tolerance
Master node and replica role in a PostgreSQL cluster for 1C, node placement in a cluster, how to change the number of replicas
Configure cluster network access
How to define a list of allowed IP addresses, basic information about security groups in a PostgreSQL for 1C database cluster, and how to assign a security group
Public IP address
How to connect a public IP address to a PostgreSQL for 1C cluster node
Link a cluster to a dedicated server
How to link a PostgreSQL for 1C cluster to a dedicated server
Migration to Managed Databases
How to migrate a PostgreSQL database to PostgreSQL Managed Databases for 1C