snipplrCallback({"id":30989,"title":"backuppostgresql","source":"
  1. #!\/bin\/bash<\/span><\/div><\/li>
  2.  <\/div><\/li>
  3. BACKUP_DIR<\/span>=\/<\/span>home\/<\/span>pg-bkp<\/div><\/li>
  4. export<\/span> PGHOST<\/span>=localhost<\/div><\/li>
  5. export<\/span> PGUSER<\/span>=postgres<\/div><\/li>
  6. export<\/span> PGPASSWORD<\/span>=secreta<\/div><\/li>
  7. export<\/span> PGPORT<\/span>=5334<\/span><\/div><\/li>
  8. time<\/span>=`<\/span>date<\/span> '+%d'<\/span>-'%B'<\/span>-'%Y'<\/span>`<\/span><\/div><\/li>
  9. \/<\/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>
  10. #echo "-- Respaldo de Base 1 terminada..."<\/span><\/div><\/li>
  11. sleep<\/span> 10<\/span><\/div><\/li>
  12. \/<\/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>
  13. #echo "-- Respaldo de Base 2 terminada..."<\/span><\/div><\/li>
  14. \/<\/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>
  15. #echo "-- Respaldo de roles terminado... iniciando el envio de los e-mail"<\/span><\/div><\/li>
  16. unset<\/span> PGPASSWORD<\/div><\/li>
  17. 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>
  18. sleep<\/span> 10<\/span><\/div><\/li>
  19. 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>
  20. sleep<\/span> 10<\/span><\/div><\/li>
  21. 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>
  22. sleep<\/span> 10<\/span><\/div><\/li>
  23. #echo "-- Envio de e-mail finalizado"<\/span><\/div><\/li>
  24. exit<\/span> 0<\/span><\/div><\/li><\/ol><\/pre>","link":"https:\/\/snipplr.com\/view\/30989\/backuppostgresql"});