LESSON 4.3

Backups and connection pooling

31:12·5,133 learners

Daniel Okafor

Course complete

In this lesson you will

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

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

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.

PRO TIP

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

PostgreSQL for Developers

92%

4.1 Transactions and isolation levels08:18 4.2 Schema migrations without downtime31:33 4.3 Backups and connection pooling31:12

Every lesson, searchable to the second.

PRIVACY · TERMS · CONTACT