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