EasyEnv
PostgreSQL
IntermediateLesson 13 of 1425 min · hands-on

Backup and Restore

Part of the PostgreSQL course

The nightly job has been writing a file to disk for eight months and nobody has ever opened it. That is not a backup, that is a hopeful file. A backup only becomes a backup the first time you restore it and see your data come back, which is why this lesson has you drop a database on purpose and bring it back from a dump before it tells you anything else.

Postgres ships with the tools already. pg_dump reads a running database and writes out a portable copy. pg_restore reads that copy back in. Everything else in this lesson is a variation on those two commands. ...

Want to learn PostgreSQL Backup and Restore in a real environment?

Click below, get a fresh Linux box with PostgreSQL ready to go, and work through Backup and Restore hands-on with an AI tutor that knows your code.

Start this lessonBackup and Restore

What you'll learn

  • Pg_dump custom format
  • Pg_restore
  • Plain SQL dumps
  • Point-in-time recovery overview

Read this lesson in your language

All lessons in this course

14 lessons
  1. 1What is PostgreSQL20 min
  2. 2psql and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types25 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes35 min
  9. 9Transactions and Isolation35 min
  10. 10Functions and Triggers35 min
  11. 11JSONB and Arrays35 min
  12. 12EXPLAIN and Query Tuning35 min
  13. 13Backup and Restore25 min
  14. 14Capstone: Design a Schema60 min

Explore other courses

Backup and Restore - PostgreSQL (English) | Engineering Courses