4 |
|
|
5 |
function do_dump () { |
function do_dump () { |
6 |
echo -n `date +"%Y-%m-%d %H:%M:%S"` $db_name |
echo -n `date +"%Y-%m-%d %H:%M:%S"` $db_name |
7 |
|
# WARNING: this might be overkill! |
8 |
psql -q -c "vacuum full analyze" $1 |
psql -q -c "vacuum full analyze" $1 |
9 |
test ! -d "$dir/$1" && mkdir "$dir/$1" |
test ! -d "$dir/$1" && ( mkdir "$dir/$1" || exit 1 ) |
10 |
file=$dir/$1/`date +%d`.sql.gz |
file=$dir/$1/`date +%d`.sql.gz |
11 |
/usr/bin/pg_dump -i $1 | gzip > $file |
/usr/bin/pg_dump -i $1 | gzip > $file |
12 |
gzip -l $file | tail -1 | sed 's/ */ /g' | cut -d" " -f-4 |
gzip -l $file | tail -1 | sed 's/ */ /g' | cut -d" " -f-4 |