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 a connection pooler and the connection pooler used by PostgreSQL for 1C
Manage users
How to create a user, change their password, and configure access to a PostgreSQL for 1C database
Configure roles and privileges
How to configure roles for PostgreSQL for 1C cluster users, grant and revoke privileges on database objects
Connect to cluster
How to connect to a PostgreSQL for 1C cluster with or without an SSL certificate in the console and 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, 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 for 1C cluster backup schedule, 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 network access to cluster
How to define the 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 floating IP address
How to connect a public floating 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
Migrate to Managed Databases
How to migrate a PostgreSQL database to Managed Databases PostgreSQL for 1C