#!/bin/sh
#резервное копирование БД postgresql

#директория сдампми
#DIR = "/home/admin/pgdump"
DIR = "pgdump"
mkdir -p $DIR

#путь к логу
LOG = "/home/admin/log/mkpgdump.log"
touch $LOG

TIMENAME = `date +%d.%m.%Y-%H.%M`

db=`psql -l | sed -n 4,/\eof/p | grep -v rows\) | grep -vE 'template[0|1]' | awk {'print $1'}`
for n in $db; do
    TIMEDUMP = `date '+%T %x'`
    echo "beckup and vacuum has been done at $TIMEDUMP : $TIMENAME on db: $n" >> $LOG
    vacuumdb -z $n >/dev/null 2>&1
    pg_dump $n | gzip -c > "$DIR/db-$n-$TIMENAME.dump.gz"
done