On Thu, Oct 6, 2011 at 1:18 PM, Carlos Mennens <carlos.mennens@xxxxxxxxx> wrote: > On Thu, Oct 6, 2011 at 3:12 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote: >> /path/to/pg_dumpall | gzip > /path/to/pgbackup-$(date -I).sql.gz > > Thanks John. I've never written a script so do I just use 'Vim' to > open a new file and just paste the following line? > > #!/bin/bash > /usr/bin/pg_dumpall | gzip > /var/db_backup/pg_backup-$(date -I).sql.gz > > Is that all I need to do or is there more steps / data involved? You could check if it executed and send an email when it fails. exec_status=(/usr/bin/pg_dumpall | gzip > /var/db_backup/pg_backup-$(date -I).sql.gz); if [[ exec_status -ne 0 ]] ;then //Send yourself an email here fi; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
