PostgreSQL Remote DB Restore

Shell script for automatic database backup restoration from remote SSH server.

Must have:

Remote server with SSH configured
sshpass lib installed on local server: sudo apt-get install sshpass

How to:

cd ~/
git clone https://github.com/augustokemp/postgresql-remote-db-restore.git
Change the variable values in the CONFIG.SH file
sh start-backup.sh

Run script every weekday at 08:00am:

sudo nano /etc/crontab
Add the following line

0 8 * * 1,2,3,4,5 root cd ~/postgresql-remote-db-restore && sh start-backup.sh