augustokemp / postgresql-remote-db-restore Public

Notifications You must be signed in to change notification settings
Fork 0
Star 1

Very useful if you develop with Postgres database and need to have an updated backup every day in the early morning.

1 star 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 16 Commits
.gitignore		.gitignore
README.md		README.md
config.sh		config.sh
dump-remote.sh		dump-remote.sh
get-backup.sh		get-backup.sh
remove-dump-remote.sh		remove-dump-remote.sh
reset-db.sh		reset-db.sh
start-backup.sh		start-backup.sh

Repository files navigation

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

About

Very useful if you develop with Postgres database and need to have an updated backup every day in the early morning.

postgres ubuntu postgresql shell-script developer-tool

Report repository

Releases

No releases published

Languages

Shell 100.0%