wi12.unix7.org

#!/bin/sh
#
# $Id$
#
dblist="db1 db2 db3"
 
pghost="pg-host.domain.org"
pgpass="pgpassword"
pguser="pguser"
 
tz="KGD"
count=4 
dstdir="/data/store"
 
for db in $dblist;do 
    mkdir -p $dstdir
    timestamp=$(date +%Y%m%d-%H%M)
    PGPASSWORD=$pgpass
    export PGPASSWORD 
    pg_dump -h $pghost -U $pguser -Fc -f $dstdir/$db--$timestamp-$tz--$pghost.sqlz $db
    find $dstdir/ | grep "$db" | sort -Vr | tail -n "+$count" | xargs -n1 rm -f 
done
#EOF