Re: Backup Database Question

what about pg_rman <http://code.google.com/p/pg-rman>?

-------------------------------------------------------------------------------------------------------------------------------------
On Fri, Oct 7, 2011 at 1:20 AM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

> On 06/10/2011 20:18, Carlos Mennens wrote:
> > On Thu, Oct 6, 2011 at 3:12 PM, John R Pierce <pierce(at)hogranch(dot)com>
> 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
> rod(at)iol(dot)ie
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>