Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Use of snapshot in logical replication - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: [HACKERS] Use of snapshot in logical replication
Date
Msg-id CAMsr+YEU1u48U6ZWOnEmAnJaSRSDguiPEr9q5W51rrtZm1wVoA@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Use of snapshot in logical replication  (sanyam jain <sanyamjain22@live.in>)
Responses Re: [HACKERS] Use of snapshot in logical replication  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On 7 June 2017 at 18:16, sanyam jain <sanyamjain22@live.in> wrote:
> Hi,
>
> Can someone explain the usage of exporting snapshot when a logical
> replication slot is created?

It's used to pg_dump the schema at a consistent point in history where
all xacts are known to be in the snapshot (and thus dumped) or known
not to be (so they'll be streamed out on the slot).

See snapbuild.c etc.


-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: [HACKERS] logical replication - possible remaining problem
Next
From: Craig Ringer
Date:
Subject: Re: [HACKERS] tap tests on older branches fail if concurrency is used