PostgreSQL Backup Script
#!/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 {} \;
#!/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 {} \;