Lesson 4.3

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.

31mIntermediate5.1k students

Overview

What this lesson covers

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

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.