PostgreSQL in production: clusters, postgresql.conf, pg_hba.conf and pg_ident.conf

55 min Debian 13 Versions PostgreSQL 15, PostgreSQL 16, PostgreSQL 17, PostgreSQL 18

Objective

Set up a production PostgreSQL server, know where each parameter comes from (file, inclusion, ALTER SYSTEM), when it takes effect, and write pg_hba.conf access rules without leaving a door open.

This lesson is part of the full course

Unlock Database administration: MariaDB, MySQL and PostgreSQL in production to read every lesson, do the exercises, access the simulations and earn your certificate.

Buy — $19 All-access pass — $99

Already enrolled? Log in.