Re: backups - Mailing list pgsql-admin

From mcelroy, tim
Subject Re: backups
Date
Msg-id 0C4841B42F87D51195BD00B0D020F5CB044B264E@MORPHEUS
Whole thread Raw
In response to backups  ("mcelroy, tim" <tim.mcelroy@bostonstock.com>)
Responses Re: backups
List pgsql-admin

Thanks Scott, great idea.  Does one use pg_restore to restore the files that pg_dumpall creates?

 -----Original Message-----
From:   Scott Marlowe [mailto:smarlowe@g2switchworks.com]
Sent:   Wednesday, May 10, 2006 3:35 PM
To:     mcelroy, tim
Cc:     'Bruno Wolff III'; 'pgsql-admin@postgresql.org'
Subject:        Re: [ADMIN] backups

On Wed, 2006-05-10 at 14:11, mcelroy, tim wrote:
> Excellent point Bruno, thanks.  I must admit that I did think of that
> and have already copied all my .conf files to the backup directory.  I
> should have noted that earlier.
>
> Thanks,
> Tim

Another thing to check is that your global data (i.e. user accounts) are
being backed up. pg_dumpall does this, but individual pg_dumps do not.

In our prod environment we run a backup of those accounts with
'pg_dumpall -g' every night as well.

pgsql-admin by date:

Previous
From: Sisyphus@mail.ru
Date:
Subject: posgresql AltLinux
Next
From: Michael Fuhr
Date:
Subject: Re: limiting number of connections from specific host or by user