Script de backup - Postgresql

#!/bin/sh

DATA=`/bin/date +%Y%m%d_%H%M%S`

VARIAVEIS DO POSTGRESQL - (IP:10.0.0.0)

# -U: usuario
# -i: ignora versao
# -h: host

#HOST="10.0.0.0"
#USER="postgres"
#DB="NOME_DB"

COMANDO

BKP="/backup/BKP-$DATA.sql"
pg_dump -h $HOST $DB -U $USER -i | gzip > $BKP.gz