--- trunk/pgsql-backup-cron.sh 2006/01/25 22:46:56 19 +++ trunk/pgsql-backup-cron.sh 2006/01/27 11:48:19 20 @@ -6,7 +6,7 @@ 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" || exit 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