What happens to transactions durring a pg_dump? - Mailing list pgsql-admin

From Chris Hoover
Subject What happens to transactions durring a pg_dump?
Date
Msg-id 1d219a6f0601090922s5224e78emd68cf850b836c2af@mail.gmail.com
Whole thread Raw
Responses Re: What happens to transactions durring a pg_dump?  (Jaime Casanova <systemguards@gmail.com>)
Re: What happens to transactions durring a pg_dump?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Sistemas C.M.P."
Date:
Subject: postgresql.conf
Next
From: Jaime Casanova
Date:
Subject: Re: What happens to transactions durring a pg_dump?