MODULE 06 / LESSON 27● READY TO LEARN

Backup and Restore

Hands-on tutorial

01 / THE CONCEPT

Understand the idea

In this lesson, explore backup and restore. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

02 / SQL EXAMPLE

◉ example.sqlSQL

pg_dump -Fc mydb > mydb.dump
pg_restore -d restored mydb.dump

Try in SQL Lab ↗

03 / KNOWLEDGE CHECK

Check your understanding

Which statement best describes backup and restore?

◈

Enjoying the lesson?

Create a free account to take the quiz and save your progress.

Create account ↗