From: Joshua D. Drake <jd@commandprompt.com>
To: mcelroy, tim <tim.mcelroy@bostonstock.com>
Cc: 'Scott Marlowe' <smarlowe@g2switchworks.com>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: backups
Date: Wed, 10 May 2006 13:14:23 -0700
Message-ID: <4462499F.4040800@commandprompt.com> (raw)
In-Reply-To: <0C4841B42F87D51195BD00B0D020F5CB044B264E@MORPHEUS>
References: <0C4841B42F87D51195BD00B0D020F5CB044B264E@MORPHEUS>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, tim.mcelroy@bostonstock.com, smarlowe@g2switchworks.com
Subject: Re: backups
In-Reply-To: <4462499F.4040800@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox