Greg Donald

PostgreSQL Backup Script

March 28, 2021

#!/bin/sh

DATE=`date +%Y%m%d%H%M%S`
DIR=/backups/pgsql
PG_DUMP=/usr/bin/pg_dump

$PG_DUMP mydatabase | bzip2 > $DIR/mydatabase_$DATE.sql.bz2

find $DIR -mtime +7 -exec rm {} \;

postgresql (3) backup (1) database (1)

About

Software maker, RC airplane enthusiast, player of strung instruments, bibliophile.

Social

Archives