Message-ID: <4462499F.4040800@commandprompt.com>
Date: Wed, 10 May 2006 13:14:23 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Mail/News 1.5 (X11/20060309)
MIME-Version: 1.0
To: "mcelroy, tim" <tim.mcelroy@bostonstock.com>
CC: "'Scott Marlowe'" <smarlowe@g2switchworks.com>,
	"'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: Re: backups
References: <0C4841B42F87D51195BD00B0D020F5CB044B264E@MORPHEUS>
In-Reply-To: <0C4841B42F87D51195BD00B0D020F5CB044B264E@MORPHEUS>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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/