Lesson 4.331mIntermediate5.1k students

Backups and connection pooling

A backup you have never restored is a hypothesis. A pooler is what stops a few hundred idle app connections from exhausting the server.

This lesson sits in Operating Postgres, part of PostgreSQL for Developers. It assumes what came before it and leads directly into the next lesson in the module.

In this lesson you will

  • Take backups and rehearse a restore
  • Understand point-in-time recovery
  • Pool connections in front of the database

Pro tip

An untested backup is not a backup. Restore one on a schedule.

Resources