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 4E9A19FA2FA for ; Wed, 10 May 2006 12:57:17 -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 23687-01 for ; Wed, 10 May 2006 12:57:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id E9CBC9FA1B0 for ; Wed, 10 May 2006 12:57:07 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 10 May 2006 15:57:07 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 10 May 2006 10:57:07 -0500 Subject: Re: backups From: Scott Marlowe To: "mcelroy, tim" Cc: "'pgsql-admin@postgresql.org'" In-Reply-To: <0C4841B42F87D51195BD00B0D020F5CB044B2641@MORPHEUS> References: <0C4841B42F87D51195BD00B0D020F5CB044B2641@MORPHEUS> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1147276626.9755.32.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 10 May 2006 10:57:07 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/109 X-Sequence-Number: 21641 On Wed, 2006-05-10 at 10:49, mcelroy, tim wrote: > Greetings, >=20 > =20 >=20 > Does the pg_dump command =E2=80=98backup=E2=80=99 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?