Re: pg_dump with both --serializable-deferrable and -j - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump with both --serializable-deferrable and -j
Date
Msg-id 8788.1422481087@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump with both --serializable-deferrable and -j  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: pg_dump with both --serializable-deferrable and -j
List pgsql-hackers
Kevin Grittner <kgrittn@ymail.com> writes:
> Kevin Grittner <kgrittn@ymail.com> wrote:
>> Having pg_dump use repeatable read transactions for the processes
>> that import the snapshot would work fine, as long as they are
>> reading a snapshot which was captured by a serializable read only
>> deferrable transaction.

> It looks like the attached patch does it (although it is only
> lightly tested so far and only on the master branch).  This seems
> like a back-patchable bug fix (to 9.3).

> Thoughts?

A comment seems essential here, because as written anybody would think
the test for a snapshot is a bug.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_dump with both --serializable-deferrable and -j
Next
From: Kevin Grittner
Date:
Subject: Re: pg_dump with both --serializable-deferrable and -j