X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5F13252ABB for ; Thu, 18 Aug 2005 23:34:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44684-01 for ; Fri, 19 Aug 2005 02:34:05 +0000 (GMT) Received: from mail.pienetworks.com (unknown [210.9.196.17]) by svr1.postgresql.org (Postfix) with ESMTP id A615752AAE for ; Thu, 18 Aug 2005 23:34:03 -0300 (ADT) Received: from tuppy.pienetworks.com (tuppy.pienetworks.com [192.168.1.72]) by mail.pienetworks.com (Postfix) with ESMTP id 86E6E3F8387 for ; Fri, 19 Aug 2005 10:34:00 +0800 (WST) Subject: On-line backup and point-in-time recovery (PITR) From: Enzo D'addario To: pgsql-admin@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2-5mdk Date: 19 Aug 2005 10:34:01 +0800 Message-Id: <1124418842.3492.34.camel@tuppy.pienetworks.com> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.038 required=5 tests=[AWL=-0.013, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/241 X-Sequence-Number: 18560 Hi All, I have a couple of questions regarding On-line backup and point-in-time recovery (PITR) in the postgres documentation: 1.How is it that we can create a tar file of the PG Data directory whilst postgres is running? 2.What happens with any DB inserts, updates, deletes etc that occur between the SELECT pg_start_backup() and the end of the tar? They would be already logged in the WAL files and already applied in the tarball, do they then get duplicated during log replay in the recover process? Thanks In Advance Enzo D'Addario... pieNETWORK's Ltd...