From: Jaime Casanova <systemguards@gmail.com>
To: Chris Hoover <revoohc@gmail.com>
Cc: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: What happens to transactions durring a pg_dump?
Date: Mon, 9 Jan 2006 15:22:09 -0500
Message-ID: <c2d9e70e0601091222y64e49593lc6f9d7809a05444b@mail.gmail.com> (raw)
In-Reply-To: <1d219a6f0601091000u45439e1dq1eb8296e8ffa3dba@mail.gmail.com>
References: <1d219a6f0601090922s5224e78emd68cf850b836c2af@mail.gmail.com>
<20060109174511.GA43775@winnie.fuhr.org>
<1d219a6f0601091000u45439e1dq1eb8296e8ffa3dba@mail.gmail.com>
On 1/9/06, Chris Hoover <revoohc@gmail.com> wrote:
>
>
> On 1/9/06, Michael Fuhr <mike@fuhr.org> wrote:
> > On Mon, Jan 09, 2006 at 12:22:27PM -0500, Chris Hoover wrote:
> > > 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.
> >
> > If you look at the pg_dump source code or turn on query logging,
> > you should see that pg_dump starts with
> >
> > BEGIN
> > SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
> >
> > See "Transaction Isolation" in the "Concurrency Control" chapter of the
> > documentation for an explanation of what that means.
> >
> >
> http://www.postgresql.org/docs/8.1/interactive/transaction-iso.html
> >
> > --
> > Michael Fuhr
> >
>
> Just to make sure I correctly understood what I read, once pg_dump issues
> the :
> BEGIN
> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
>
> The backup will only see transactions that were commited before the
> isolation level was set Is this correct? Any transactions that are commited
> while the backup is running are not seen by pg_dump.
>
> Correct?
>
> Thanks,
>
> Chris
>
correct
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: systemguards@gmail.com, revoohc@gmail.com, mike@fuhr.org
Subject: Re: What happens to transactions durring a pg_dump?
In-Reply-To: <c2d9e70e0601091222y64e49593lc6f9d7809a05444b@mail.gmail.com>
References: <1d219a6f0601090922s5224e78emd68cf850b836c2af@mail.gmail.com> <20060109174511.GA43775@winnie.fuhr.org> <1d219a6f0601091000u45439e1dq1eb8296e8ffa3dba@mail.gmail.com> <c2d9e70e0601091222y64e49593lc6f9d7809a05444b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox