PostgreSQL

Available PostgreSQL versions, fixed and arbitrary cluster node configurations

Features of local disks

How to create a PostgreSQL cluster and databases

How to change PostgreSQL settings

How to add extensions to PostgreSQL databases, extension descriptions and list of dependent extensions

How to encrypt data, security restrictions and examples of how to use the pgcrypto extension

Pool size, PgBouncer pooling modes and how to change the mode

How to create a user, change his password, configure database access and work with privileges

How to connect to PostgreSQL cluster with or without SSL certificate in console and from different programming languages

How to track the status of cluster, nodes and databases, how to export metrics in Prometheus format

What is stored on the cluster disks and what to check when the amount of disk space used grows

How to change the configuration of a node cluster

Backup schedule, backup retention period and how to restore the cluster

The role of master node and replicas in a cluster, how to change the number of replicas

How to restrict access to the cluster from certain addresses for security purposes

How to connect a public IP address to a PostgreSQL cluster node

How to create a network with a dedicated server

How to create a replication slot, configure logical replication using it, view replication slot status and other instructions

How to migrate PostgreSQL database to cloud databases