Get a listing of postgres databases
psql -U postfix -h localhost -l -t | awk ‘/^ [a-zA-Z]+/ { print $1; }’ | grep -v ‘^\(template0\)’ | while read DBNAME do … done #! /bin/sh # Keep n days worth of backups GENERATIONS=180 BACKUP_DIR=”/var/backups/generational/pgsql”; BACKUP_CURRENT=”/var/backups/pgsql”; DATE=`date +’%Y%m%d’` HOSTNAME=`hostname` DBUSER=”postgres” # load defaults, over-riding script supplied values [ -f /etc/default/pgbackup ] && . …