X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DE6309DC83F for ; Mon, 9 Jan 2006 13:22:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16086-04 for ; Mon, 9 Jan 2006 13:22:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.199]) by postgresql.org (Postfix) with ESMTP id A19799DC814 for ; Mon, 9 Jan 2006 13:22:29 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so2555793wxc for ; Mon, 09 Jan 2006 09:22:30 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=XLVb/ptkdI7hKWZtu3kcIpuA7zPBamyjTsAIZFpG2KY/xJxRwJE4PiYUdn8CGjF+dVr7RImP5gdn4mJ3hOHDNonu4ucPzZfqqBrmpZIMO9jxH2oU4+K5UPVbji1H8AhUM9ahVM5+pxRM+izXTbUhtiMumjBTPGzfg9fgvUtruCY= Received: by 10.70.13.4 with SMTP id 4mr12094941wxm; Mon, 09 Jan 2006 09:22:28 -0800 (PST) Received: by 10.70.84.7 with HTTP; Mon, 9 Jan 2006 09:22:27 -0800 (PST) Message-ID: <1d219a6f0601090922s5224e78emd68cf850b836c2af@mail.gmail.com> Date: Mon, 9 Jan 2006 12:22:27 -0500 From: Chris Hoover To: "pgsql-admin@postgresql.org" Subject: What happens to transactions durring a pg_dump? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_82557_21568604.1136827347997" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.1 required=5 tests=[AWL=0.099, HTML_MESSAGE=0.001] X-Spam-Score: 0.1 X-Spam-Level: X-Archive-Number: 200601/91 X-Sequence-Number: 20179 ------=_Part_82557_21568604.1136827347997 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I'm trying to understand better what happens to a transaction that is commited in the middle of a pg_dump. Is the transaction included in the database dump, or is it excluded. Example pg_dump starts - transaction is begun - row from table a is deleted - row from table b is updated - transaction is commited pg_dump finishes What happens to the deleted row and the updated row with respect to the backup file. 1. If they are done before table a and table b are backed up? 2. If table a is dumped and table b is not? Thanks, Chris ------=_Part_82557_21568604.1136827347997 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I'm trying to understand better what happens to a transaction that is commited in the middle of a pg_dump.  Is the transaction included in the database dump, or is it excluded.

Example

pg_dump starts
    - transaction is begun
      - row from table a is deleted
      - row from table b is updated
    - transaction is commited
pg_dump finishes

What happens to the deleted row and the updated row with respect to the bac= kup file.

1.  If they are done before table a and table b are backed up?

2.  If table a is dumped and table b is not?

Thanks,

Chris
------=_Part_82557_21568604.1136827347997--