PostgreSQL for Developers
LESSON 4.3

Backups and connection pooling

Learn key techniques and workflows in PostgreSQL for Developers.

31m
intermediate
5,133 students

Overview

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

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