Restoring a binary backup (Simple)
We have now discussed several different methods for obtaining a binary backup. What do we actually do with these binary backup files? We'll cover a simple restore since there is no supplied utility that performs this task.
Getting ready
Please refer to the Getting a basic export (Simple) recipe to bootstrap our sample
database. Then, we want a very simple backup to restore. We should stop the database to avoid any extra work using the following commands:
$> pg_ctl -D /db/pgdata stop -m fast $> tar -C /db/pgdata --exclude=pg_xlog -cz \ -f /db/backup/backup.tar.gz . $> tar -C /db/pgdata/pg_xlog --exclude=archive_status \ --exclude=archive_status -czf /db/backup/xlog.tar.gz .
Once these files are safely stored, ...
Get Instant PostgreSQL Backup and Restore How-to now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.