Skip to content

Instantly share code, notes, and snippets.

@pablodevopensource

pablodevopensource/pgbackup.sh

Last active August 29, 2015 14:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pablodevopensource/fb8e47896546d29468e7 to your computer and use it in GitHub Desktop.
Save pablodevopensource/fb8e47896546d29468e7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pgbackup.sh
#!/bin/sh
BACKUP_DIR=/home/sentry/backup
cd $BACKUP_DIR
#Exportamos la base de datos
pg_dump -h direccion_ip -U user -d your_sentry_db_name > dbbackup.sql
#compresion de base de datos
tar -cf $BACKUP_DIR/bd$(date +%d-%m-%y_%H:%M).tar dbbackup.sql
#borrado de base de datos despues de la compresion
rm -rf $BACKUP_DIR/dbbackup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment