Installing WAL-E (Continuous archiving for Postgres) on CentOS 6.7
Install daemontools:
# rpm -Uvh ftp://ftp.pbone.net/mirror/ftp5.gwdg.de/pub/opensuse/repositories/home:/weberho:/qmailtoaster/CentOS_CentOS-6/x86_64/daemontools-0.76-5.3.x86_64.rpmInstall requirements:
# yum install python34 python34-setuptools lzop pv# easy_install-3.4 pip
# pip install --upgrade pip
# pip install wal-e boto
# pip install wal-e boto
Setup WAL-E:
# sudo mkdir -p /etc/wal-e.d/env
# echo '' | sudo tee /etc/wal-e.d/env/AWS_REGION
# echo '' | sudo tee /etc/wal-e.d/env/AWS_ACCESS_KEY_ID
# echo '' | sudo tee /etc/wal-e.d/env/AWS_SECRET_ACCESS_KEY
# echo 's3://pgbackup/' | sudo tee /etc/wal-e.d/env/WALE_S3_PREFIX
# sudo chown -R root:postgres /etc/wal-e.d
Scheduled backup:
Restoring:
https://edwardsamuel.wordpress.com/2016/06/02/restoring-wal-e-postgresql-database-backup/-- vladget