From the course: Database Foundations: Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Restore a Postgres database

Restore a Postgres database

From the course: Database Foundations: Administration

Start my 1-month free trial

Restore a Postgres database

“

- [Instructor] Anyone that has management responsibility over the valuable data stored in a database, needs to be very familiar with the process of restoring a database from the backup files that have been archived. After all, database backups are worthless. If you don't know how to make use of them when a disaster strikes. So, let's pretend that the unthinkable has actually happened to our original server. It was struck by lightning and fried to a crisp. The entire business is now shut down and losing money, and we need to get the two trees database back up and running on a brand new server as fast as possible. On the PostgreSQL platform, this means turning once again to the command line for moving files into place and restoring them to the server. There's a bunch of commands that we need to execute, and I've written all of them out for you in the Restore_ PostgreSQL.txt file that you'll find in the course exercise…

Contents