Re: backups

mcelroy, tim wrote:
> Thanks Scott, great idea.  Does one use pg_restore to restore the files
> that pg_dumpall creates?

No, oddly you use psql.

Sincerely,

Joshua D. Drake

>
>
>  -----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.
>


--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/