Re: Logical decoding on standby

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Simon Riggs <simon(dot)riggs(at)2ndquadrant(dot)com>
Subject: Re: Logical decoding on standby
Date: 2017-01-04 04:08:55
Message-ID: CAMsr+YEzC=-+eV09A=ra150FjtkmTqT5Q70PiqBwytbOR3cshg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 23 December 2016 at 18:11, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
> On 22 December 2016 at 14:21, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
>
> changes-in-0001-v2.diff shows the changes to PostgresNode.pm per
> Michael's comments, and applies on top of 0001.
>
> I also attach a patch to add a new CREATE_REPLICATION_SLOT option per
> Petr's suggestion, so you can request a slot be created
> WITHOUT_SNAPSHOT. This replaces the patch series's behaviour of
> silently suppressing snapshot export when a slot was created on a
> replica. It'll conflict (easily resolved) if applied on top of the
> current series.

OK, patch series updated.

0001 incorporates the changes requested by Michael Paquier. Simon
expressed his intention to commit this after updates, in the separate
thread for

The pg_lsn patch is gone; I worked around it using the server to work with LSNs.

0002 (endpos) is unchanged.

0003 is new, some minimal tests for pg_recvlogical. It can be squashed
with 0002 (pg_recvlogical --endpos) if desired.

0004 (pg_recvlogical wrapper) is unchanged.

0005 (new streaming rep tests) is updated for the changes in 0001,
otherwise unchanged. Simon said he wanted to commit this soon.

0006 (timeline following) is unchanged except for updates to be
compatible with 0001.

0007 is the optional snapshot export requested by Petr.

0008 is unchanged.

0009 is unchanged except for updates vs 0001 and use of the
WITHOUT_SNAPSHOT option added in 0007.

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

Attachment Content-Type Size
0001-PostgresNode-methods-to-wait-for-node-catchup.patch text/x-patch 10.7 KB
0002-Add-an-optional-endpos-LSN-argument-to-pg_recvlogica.patch text/x-patch 10.6 KB
0003-Add-some-minimal-tests-for-pg_recvlogical.patch text/x-patch 2.8 KB
0004-Add-a-pg_recvlogical-wrapper-to-PostgresNode.patch text/x-patch 5.6 KB
0005-Expand-streaming-replication-tests-to-cover-hot-stan.patch text/x-patch 6.2 KB
0006-Follow-timeline-switches-in-logical-decoding.patch text/x-patch 20.9 KB
0007-Make-snapshot-export-on-logical-slot-creation-option.patch text/x-patch 8.3 KB
0008-ERROR-if-timeline-is-zero-in-walsender.patch text/x-patch 940 bytes
0009-Logical-decoding-on-standby.patch text/x-patch 100.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2017-01-04 04:15:57 Re: Logical decoding on standby
Previous Message Haribabu Kommi 2017-01-04 04:00:32 Re: gettimeofday is at the end of its usefulness?