X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A80899FA2CB for ; Wed, 10 May 2006 16:10:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49200-04 for ; Wed, 10 May 2006 16:10:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id D282D9FA293 for ; Wed, 10 May 2006 16:10:24 -0300 (ADT) Received: (qmail 17747 invoked by uid 500); 10 May 2006 19:11:38 -0000 Date: Wed, 10 May 2006 14:11:38 -0500 From: Bruno Wolff III To: "mcelroy, tim" Cc: 'Scott Marlowe' , "'pgsql-admin@postgresql.org'" Subject: Re: backups Message-ID: <20060510191138.GA4099@wolff.to> Mail-Followup-To: Bruno Wolff III , "mcelroy, tim" , 'Scott Marlowe' , "'pgsql-admin@postgresql.org'" References: <0C4841B42F87D51195BD00B0D020F5CB044B2643@MORPHEUS> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0C4841B42F87D51195BD00B0D020F5CB044B2643@MORPHEUS> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/115 X-Sequence-Number: 21647 On Wed, May 10, 2006 at 11:56:20 -0400, "mcelroy, tim" wrote: > Thanks for the quick answer Scott. I thought so but wanted to double-check. > I was asked by the person who performs our system backups if just backing up > the directory where I put the nightly backups (created with pg_dump) was > enough. I also have them backing up /var/lib/pgsql and everything under > that and they're complaining that it's taking too long. I would think we > would also want to back up the pg_xlog directory though. Or is that > overkill? Is there a standard in the PG community I should follow? Is just > performing the pg_dump and saving that to tape enough? I just don't want to > get bit in the butt if I tell him to not back something up that should be > backed up. You might want to make sure you have the configuration files backed up as well.