what about pg_rman <http://code.google.com/p/pg-rman>?
------------------------------------------------------------------------------------------------------------------------------------- On Fri, Oct 7, 2011 at 1:20 AM, Raymond O'Donnell <[email protected]> wrote: > On 06/10/2011 20:18, Carlos Mennens wrote: > > On Thu, Oct 6, 2011 at 3:12 PM, John R Pierce <[email protected]> > 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? > > I think you also need to make it executable: > > chmod u+x my_backup_script > > ...or something like that. > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > [email protected] > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
