Configures the WAL-E backup tool for Postgres.
This allows you to quickly recover your database from an S3 bucket.
Force the WAL archives to swap, so that you can ensure that your backup works.
SELECT pg_switch_xlog();
Suppose you've corrupted or deleted your postgres data directory:
- stop the database:
sudo service postgresql stop
. - delete the postgres data directory.
- look in
recovery.example
, there's a command here for downloading a base backup of the database. - copy
recovery.example
torecovery.conf
. this file directs postgres to perform recovery. - start the database server:
sudo service postgresql start
This should almost never happen, and is a risky operation.
if you ever find yourself in a sticky situation where you are unable to recover fully with WAL-E, and you have a partial backup of your data directory. You have the nuclear option of resetting your log directory.
/usr/lib/postgresql/9.3/bin/pg_resetxlog /mnt/postgresql/