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 D467B9FA432 for ; Wed, 10 May 2006 13:01:57 -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 22607-09 for ; Wed, 10 May 2006 13:01:43 -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 3BDE99FA425 for ; Wed, 10 May 2006 13:01:39 -0300 (ADT) Received: by MORPHEUS with Internet Mail Service (5.5.2653.19) id <2R02CWN8>; Wed, 10 May 2006 11:56:30 -0400 Message-ID: <0C4841B42F87D51195BD00B0D020F5CB044B2643@MORPHEUS> From: "mcelroy, tim" To: 'Scott Marlowe' Cc: "'pgsql-admin@postgresql.org'" Subject: Re: backups Date: Wed, 10 May 2006 11:56:20 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6744A.478576AE" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/110 X-Sequence-Number: 21642 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_01C6744A.478576AE Content-Type: text/plain; charset="UTF-8" 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. Tim -----Original Message----- From: Scott Marlowe [mailto:smarlowe@g2switchworks.com] Sent: Wednesday, May 10, 2006 11:57 AM To: mcelroy, tim Cc: 'pgsql-admin@postgresql.org' Subject: Re: [ADMIN] backups On Wed, 2006-05-10 at 10:49, mcelroy, tim wrote: > Greetings, > > > > Does the pg_dump command 'backup' the pg_xlog files? No. Those are internal files used by the database to maintain transactional integrity. The pg_dump command backs up the database as snapshotted at a specific point of time. What are you trying to accomplish? ------_=_NextPart_001_01C6744A.478576AE Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable RE: [ADMIN] backups

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.

Tim

-----Original Message-----
From: Scott Marlowe [mailto:smarlowe@g2switchworks= .com]
Sent: Wednesday, May 10, 2006 11:57 AM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] backups

On Wed, 2006-05-10 at 10:49, mcelroy, tim = wrote:
> Greetings,
>
>
>
> Does the pg_dump command 'backup' the pg_xlog = files?

No.  Those are internal files used by the = database to maintain
transactional integrity.  The pg_dump command = backs up the database as
snapshotted at a specific point of time.

What are you trying to accomplish?

------_=_NextPart_001_01C6744A.478576AE--