--- trunk/pgsql-backup-cron.sh 2006/01/25 22:12:28 17 +++ trunk/pgsql-backup-cron.sh 2006/01/25 22:46:56 19 @@ -4,8 +4,9 @@ function do_dump () { echo -n `date +"%Y-%m-%d %H:%M:%S"` $db_name + # WARNING: this might be overkill! psql -q -c "vacuum full analyze" $1 - test ! -d "$dir/$1" && mkdir "$dir/$1" + test ! -d "$dir/$1" && mkdir "$dir/$1" || exit 1 file=$dir/$1/`date +%d`.sql.gz /usr/bin/pg_dump -i $1 | gzip > $file gzip -l $file | tail -1 | sed 's/ */ /g' | cut -d" " -f-4