Backup file postgresql

Post date: 30-giu-2015 9.41.51

#!/bin/bash

#

#BACKUP TOTALE

#stop postgres

service postgresql stop

sleep 30

#faccio backup totale dei file (i file si trovano nella cartella main)

tar -cvpzf pg-back`date +-\%d-\%m-\%Y`.tgz /var/lib/postgresql/

#riavvio postgresql

service postgresql start

#per il ripristino

#service postgresql stop

#tar -xvpzf pg-back-GGMMAAAA.tgz -C /

#service postgres start