PostgreSQL
Versions and configurations
Available PostgreSQL versions, fixed and arbitrary cluster node configurations
Disks
Basic information about the disks used in the PostgreSQL database cluster
Create a cluster
How to create a cluster and PostgreSQL databases
PostgreSQL Settings
How to change PostgreSQL settings
Extensions
How to add extensions to PostgreSQL databases, extension descriptions and list of dependent extensions
Data Encryption
How to encrypt data, security restrictions and examples of how to use the pgcrypto extension
Pooler Connections
Pool size, PgBouncer pooling modes and how to change the mode
User Management
How to create a user, change their password, set up database access and work with privileges
Connect to a cluster
How to connect to a PostgreSQL cluster with or without SSL certificate in console and from different programming languages
Monitoring cluster, nodes and databases
How to monitor cluster, node and database health, how to export metrics in Prometheus format
Disk space usage
What is stored on cluster disks and what to check when disk space usage grows
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
Create a network with a dedicated server
How to create a network with a dedicated server
Logical Replication Slots
How to create a replication slot, configure logical replication with it, view replication slot status and other instructions
Migration to Cloud Databases
How to Migrate a PostgreSQL Database to Cloud Databases