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 4B8A49FA38E for ; Wed, 10 May 2006 16:16:45 -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 53010-01 for ; Wed, 10 May 2006 16:16:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from morpheus.bostonstock.com (unknown [192.233.205.44]) by postgresql.org (Postfix) with ESMTP id 5D0569FA293 for ; Wed, 10 May 2006 16:16:29 -0300 (ADT) Received: by MORPHEUS with Internet Mail Service (5.5.2653.19) id <2R02CXWJ>; Wed, 10 May 2006 15:11:17 -0400 Message-ID: <0C4841B42F87D51195BD00B0D020F5CB044B264B@MORPHEUS> From: "mcelroy, tim" To: 'Bruno Wolff III' Cc: "'pgsql-admin@postgresql.org'" Subject: Re: backups Date: Wed, 10 May 2006 15:11:16 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C67465.83111DB6" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/116 X-Sequence-Number: 21648 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C67465.83111DB6 Content-Type: text/plain; charset="iso-8859-1" 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 -----Original Message----- From: Bruno Wolff III [mailto:bruno@wolff.to] Sent: Wednesday, May 10, 2006 3:12 PM To: mcelroy, tim Cc: 'Scott Marlowe'; 'pgsql-admin@postgresql.org' Subject: Re: backups 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. ------_=_NextPart_001_01C67465.83111DB6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: backups

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


 -----Original Message-----
From:   Bruno Wolff III [mailto:bruno@wolff.to]
Sent:   Wednesday, May 10, 2006 3:12 = PM
To:     mcelroy, tim
Cc:     'Scott Marlowe'; = 'pgsql-admin@postgresql.org'
Subject:        = Re: backups

On Wed, May 10, 2006 at 11:56:20 -0400,
  "mcelroy, tim" = <tim.mcelroy@bostonstock.com> 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.

------_=_NextPart_001_01C67465.83111DB6--