PostgreSQL
Versions and configurations
Available PostgreSQL versions, fixed and arbitrary cluster node configurations
Local disks
Features of local disks
Create a cluster
How to create a PostgreSQL cluster and databases
PostgreSQL settings
How to change PostgreSQL settings
Connect extensions
List of dependent extensions and how to connect extensions to PostgreSQL databases
Connection Pooler
Pool size, PgBouncer pooling modes and how to change the mode
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 with or without SSL certificate in console and from different programming languages
Cluster, node and database monitoring
How to track the status of the cluster, nodes and databases, how to export metrics in Prometheus format
Disk space utilization
What is stored on the cluster disks and what to check when the amount of disk space used grows
Scale the cluster
How to change the configuration of a node cluster
Backup
Backup schedule, backup retention period and how to restore the cluster
Cluster fault tolerance
The role of master node and replicas 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 purposes
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 and configure logical replication using it
Migration to cloud databases
How to migrate PostgreSQL database to cloud databases