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@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, May 10, 2006 3:35 PM
To: mcelroy, tim
Cc: 'Bruno Wolff III'; 'pgsql-admin@xxxxxxxxxxxxxx'
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/
