snipplrCallback({"id":30989,"title":"backuppostgresql","source":"
#!\/bin\/bash<\/span><\/div><\/li> <\/div><\/li> BACKUP_DIR<\/span>=\/<\/span>home\/<\/span>pg-bkp<\/div><\/li> export<\/span> PGHOST<\/span>=localhost<\/div><\/li> export<\/span> PGUSER<\/span>=postgres<\/div><\/li> export<\/span> PGPASSWORD<\/span>=secreta<\/div><\/li> export<\/span> PGPORT<\/span>=5334<\/span><\/div><\/li> time<\/span>=`<\/span>date<\/span> '+%d'<\/span>-'%B'<\/span>-'%Y'<\/span>`<\/span><\/div><\/li> \/<\/span>usr\/<\/span>lib\/<\/span>postgresql\/<\/span>8.4<\/span>\/<\/span>bin\/<\/span>pg_dump -p<\/span> $PGPORT<\/span> -h<\/span> $PGHOST<\/span> -U<\/span> $PGUSER<\/span> base1 |<\/span> gzip<\/span> ><\/span> $BACKUP_DIR<\/span>\/<\/span>base1-$time<\/span>.gz<\/div><\/li> #echo "-- Respaldo de Base 1 terminada..."<\/span><\/div><\/li> sleep<\/span> 10<\/span><\/div><\/li> \/<\/span>usr\/<\/span>lib\/<\/span>postgresql\/<\/span>8.4<\/span>\/<\/span>bin\/<\/span>pg_dump -p<\/span> $PGPORT<\/span> -h<\/span> $PGHOST<\/span> -U<\/span> $PGUSER<\/span> base2 |<\/span> gzip<\/span> ><\/span> $BACKUP_DIR<\/span>\/<\/span>base2-$time<\/span>.gz<\/div><\/li> #echo "-- Respaldo de Base 2 terminada..."<\/span><\/div><\/li> \/<\/span>usr\/<\/span>lib\/<\/span>postgresql\/<\/span>8.4<\/span>\/<\/span>bin\/<\/span>pg_dumpall -p<\/span> $PGPORT<\/span> -h<\/span> $PGHOST<\/span> -U<\/span> $PGUSER<\/span> -l<\/span> postgres -r<\/span> |<\/span> gzip<\/span> ><\/span> $BACKUP_DIR<\/span>\/<\/span>roles-$time<\/span>.gz<\/div><\/li> #echo "-- Respaldo de roles terminado... iniciando el envio de los e-mail"<\/span><\/div><\/li> unset<\/span> PGPASSWORD<\/div><\/li> nail -s<\/span> "PostgreSql Backup ("<\/span>$time<\/span>") [base1]"<\/span> -a<\/span> $BACKUP_DIR<\/span>\/<\/span>base1-$time<\/span>.gz -c<\/span> correo_copia@<\/span>yahoo.com.mx correo_respaldo@<\/span>gmail.com <<\/span> \/<\/span>dev\/<\/span>null<\/div><\/li> sleep<\/span> 10<\/span><\/div><\/li> nail -s<\/span> "PostgreSql Backup ("<\/span>$time<\/span>") [base2]"<\/span> -a<\/span> $BACKUP_DIR<\/span>\/<\/span>base2-$time<\/span>.gz -c<\/span> correo_copia@<\/span>yahoo.com.mx correo_respaldo@<\/span>gmail.com <<\/span> \/<\/span>dev\/<\/span>null<\/div><\/li> sleep<\/span> 10<\/span><\/div><\/li> nail -s<\/span> "PostgreSql Backup ("<\/span>$time<\/span>") [roles]"<\/span> -a<\/span> $BACKUP_DIR<\/span>\/<\/span>roles-$time<\/span>.gz -c<\/span> correo_copia@<\/span>yahoo.com.mx correo_respaldo@<\/span>gmail.com <<\/span> \/<\/span>dev\/<\/span>null<\/div><\/li> sleep<\/span> 10<\/span><\/div><\/li> #echo "-- Envio de e-mail finalizado"<\/span><\/div><\/li> exit<\/span> 0<\/span><\/div><\/li><\/ol><\/pre>","link":"https:\/\/snipplr.com\/view\/30989\/backuppostgresql"});