Skip to content

Instantly share code, notes, and snippets.

@horaciod
Created June 25, 2017 02:18
Show Gist options
  • Save horaciod/6509a7cdfb6cbe8c7537e6e9963e4be1 to your computer and use it in GitHub Desktop.
Save horaciod/6509a7cdfb6cbe8c7537e6e9963e4be1 to your computer and use it in GitHub Desktop.
rutina de backup para las bases de datos postgresql
#!/bin/bash
fecha=`date +%Y-%m-%d_%H_%M`
mkdir $fecha
cd $fecha
echo "copia base de datos dbname"
ssh -C desarrollo@remoto.com 'export PGPASSWORD=clave_postgresql; /usr/lib/postgresql/9.5/bin/pg_dump -v -Uusuario -hlocalhost -p5432 dbname '>archivo.sql
echo "comprimiendo"
gzip -f -9 *.sql
echo "LISTO creado en carpeta "
echo $fecha
ls -l
echo "copiando a carpeta remota en google"
gsutil cp *.sql.gz gs://bucket/directoriobucket/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment