PostgreSQL
Versions and Configurations
Available PostgreSQL versions, fixed and custom cluster node configurations
Volumes
General information about volumes used in a PostgreSQL database cluster
Create a cluster
How to create a PostgreSQL cluster and databases
Settings
How to change PostgreSQL settings
Extensions
How to add extensions to PostgreSQL databases, extension descriptions, and a list of dependent extensions
Data encryption
How to encrypt data in PostgreSQL, security limitations, and examples of using the pgcrypto extension
Connection pooler
Pool size, PgBouncer pooling modes, and how to change the mode in a PostgreSQL cluster
User management
How to create a user, change their password, configure database access, and manage privileges
Connect to a cluster
How to connect to a PostgreSQL cluster with an SSL certificate or without an SSL certificate in the console and from various programming languages
Monitoring of cluster, nodes, and databases
How to track the status of a PostgreSQL cluster, its nodes, and databases, and how to export metrics in Prometheus format
Cluster logs
How to enable PostgreSQL cluster logging, get logs, and disable cluster logging
Using disk space
What is stored on PostgreSQL cluster disks and what to check when the amount of used disk space grows
Scale a cluster
How to change the configuration of PostgreSQL cluster nodes
Backups
PostgreSQL cluster backup schedule, retention period, and how to restore a cluster from a backup
Cluster fault tolerance
The role of the master node and replicas in a PostgreSQL cluster, node placement 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 PostgreSQL database cluster, and how to assign a security group
Public IP address
How to connect a public IP address to a PostgreSQL cluster node
Link a cluster to a dedicated server
How to link a PostgreSQL cluster to a dedicated server
Logical replication slots
How to create a replication slot, use it to configure logical replication, view the replication slot status, and other instructions
Migration to Managed Databases
How to migrate a PostgreSQL database to Managed Databases