PostgreSQL streaming replication: standby, replication slots and failover

1 h 5 min Debian 13 Versions PostgreSQL 15, PostgreSQL 16, PostgreSQL 17, PostgreSQL 18

Objective

Set up one or more PostgreSQL standbys that follow the primary in real time, monitor them with the right views, and know how to promote a standby cleanly on the day the primary goes down.

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.