X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 33A40D1BC59 for ; Wed, 17 Mar 2004 19:30:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38276-10 for ; Wed, 17 Mar 2004 15:30:06 -0400 (AST) Received: from mail.guest-tek.com (unknown [209.82.99.131]) by svr1.postgresql.org (Postfix) with ESMTP id 7FD82D1E883 for ; Wed, 17 Mar 2004 15:30:01 -0400 (AST) Received: from TSDJKERKHOF ([209.82.99.130]) by mail.guest-tek.com (8.11.6/8.11.6) with SMTP id i2HJS2C09491 for ; Wed, 17 Mar 2004 12:28:03 -0700 From: "Jack Kerkhof" To: Subject: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running? Date: Wed, 17 Mar 2004 12:29:56 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/247 X-Sequence-Number: 12816 If I run pgdump, and while it is running, execute INSERT, UPDATE, DELETE commands, what will happen to the pgdump results? - Is pgdump all contained in a single transaction, so it just gets the 'before' data state, - Do some of the modifications end up in the dump, but not others depending upon where the dump is at that exact moment? The pgdump documentation is not clear on these transaction concurrency issues. Thanks, Jack