Training Trains Internship
Student login
← PostgreSQL learning path
PostgreSQL · Module 10 of 10

Backup, replication and operations

Keep Postgres reliable in production.

📖 Key ideas

  1. pg_dump backs up one database; pg_restore restores it.
  2. Point-in-time recovery uses base backups plus WAL archiving.
  3. Streaming replication creates read replicas and standbys.
  4. Connection poolers like PgBouncer handle many clients.
  5. Monitor with pg_stat_statements for slow queries.
💡 Real-life example: WAL is a diary of every change: replay the diary and you can rebuild any moment.
pg_dumpLogical backup tool
WALWrite-Ahead Log
Read replicaCopy serving read queries
PgBouncerConnection pooler