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