Backup up Postgres Databases

April 22, 2018

I wanted to dump the contents of some postgres databases into files, complete with a date timestamp. I also wanted to gzip the files to save disk space.

This can be done with the following in the postgres user crontab file:

0 4 *** pg_dump databasename | gzip > /home/drumcoder/db/database-`date '+%Y%m%d%H%M%S'`.sql.gz