Content-Type: multipart/mixed; boundary="------------HRhWKLrD40wwLBspPWEZfzx5"
Message-ID: <002cc876-0838-2821-e9d8-bb3791386814@gmail.com>
Date: Tue, 11 Apr 2023 11:04:50 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.9.1
Subject: Re: Minimal logical decoding on standbys
Content-Language: en-US
From: "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
To: Noah Misch <noah@leadboat.com>, Andres Freund <andres@anarazel.de>
Cc: Amit Kapila <amit.kapila16@gmail.com>,
 Alvaro Herrera <alvherre@alvh.no-ip.org>, Jeff Davis <pgsql@j-davis.com>,
 Robert Haas <robertmhaas@gmail.com>, Thomas Munro <thomas.munro@gmail.com>,
 Ibrar Ahmed <ibrar.ahmad@gmail.com>, Amit Khandekar
 <amitdkhan.pg@gmail.com>, fabriziomello@gmail.com,
 tushar <tushar.ahuja@enterprisedb.com>,
 Rahila Syed <rahila.syed@2ndquadrant.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
References: <1903ca9b-1dc9-20a6-404a-d4c460c7bdcc@gmail.com>
 <CAA4eK1KFrxgQJt7kc-_o5ruLvafw_FR=NUizA8A7Bp1TDOEj8g@mail.gmail.com>
 <2b002763-f39f-0814-e98e-c48989ddc3c3@gmail.com>
 <3c9d4998-a338-081f-a5f6-d038ead75384@gmail.com>
 <20230407055618.33gjg5vd5hq3kje4@awork3.anarazel.de>
 <71c3d91a-6b3b-5c0a-ffb9-630f17fe693e@gmail.com>
 <20230407075009.igg7be27ha2htkbt@awork3.anarazel.de>
 <1e923731-ed09-3621-c8b9-61f938b4c355@gmail.com>
 <20230407154757.ywqnldz4nsycap3g@awork3.anarazel.de>
 <20230407181226.6oyt4jcazy6eh7rx@awork3.anarazel.de>
 <20230411053657.GA1177147@rfd.leadboat.com>
 <7eb26a22-a6b2-f938-6d3c-6adcf4785004@gmail.com>
 <e217cdaf-53a1-6d41-59e2-4f4a8bbe9f23@gmail.com>
In-Reply-To: <e217cdaf-53a1-6d41-59e2-4f4a8bbe9f23@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/002cc876-0838-2821-e9d8-bb3791386814%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------HRhWKLrD40wwLBspPWEZfzx5
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

On 4/11/23 10:55 AM, Drouvot, Bertrand wrote:
> Hi,
> 
> I think we might want to add:
> 
> $node_primary->wait_for_replay_catchup($node_standby);
> 
> before calling the slot creation.
> 
> It's done in the attached, would it be possible to give it a try please?

Actually, let's also wait for the cascading standby to catchup too, like done in the attached.

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
--------------HRhWKLrD40wwLBspPWEZfzx5
Content-Type: text/plain; charset=UTF-8; name="hoverfly2.patch"
Content-Disposition: attachment; filename="hoverfly2.patch"
Content-Transfer-Encoding: base64

ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlY292ZXJ5L3QvMDM1X3N0YW5kYnlfbG9naWNhbF9k
ZWNvZGluZy5wbCBiL3NyYy90ZXN0L3JlY292ZXJ5L3QvMDM1X3N0YW5kYnlfbG9naWNhbF9k
ZWNvZGluZy5wbAppbmRleCBiYTk4YTE4YmQyLi45NGE4Mzg0YzMxIDEwMDY0NAotLS0gYS9z
cmMvdGVzdC9yZWNvdmVyeS90LzAzNV9zdGFuZGJ5X2xvZ2ljYWxfZGVjb2RpbmcucGwKKysr
IGIvc3JjL3Rlc3QvcmVjb3ZlcnkvdC8wMzVfc3RhbmRieV9sb2dpY2FsX2RlY29kaW5nLnBs
CkBAIC02NTMsOSArNjUzLDE1IEBAICRub2RlX3N0YW5kYnktPnJlbG9hZDsKICRub2RlX3By
aW1hcnktPnBzcWwoJ3Bvc3RncmVzJywgcVtDUkVBVEUgREFUQUJBU0UgdGVzdGRiXSk7CiAk
bm9kZV9wcmltYXJ5LT5zYWZlX3BzcWwoJ3Rlc3RkYicsIHFxW0NSRUFURSBUQUJMRSBkZWNv
ZGluZ190ZXN0KHggaW50ZWdlciwgeSB0ZXh0KTtdKTsKIAorIyBXYWl0IGZvciB0aGUgc3Rh
bmRieSB0byBjYXRjaHVwIGJlZm9yZSBjcmVhdGluZyB0aGUgc2xvdHMKKyRub2RlX3ByaW1h
cnktPndhaXRfZm9yX3JlcGxheV9jYXRjaHVwKCRub2RlX3N0YW5kYnkpOworCiAjIGNyZWF0
ZSB0aGUgbG9naWNhbCBzbG90cwogY3JlYXRlX2xvZ2ljYWxfc2xvdHMoJG5vZGVfc3RhbmRi
eSwgJ3Byb21vdGlvbl8nKTsKIAorIyBXYWl0IGZvciB0aGUgY2FzY2FkaW5nIHN0YW5kYnkg
dG8gY2F0Y2h1cCBiZWZvcmUgY3JlYXRpbmcgdGhlIHNsb3RzCiskbm9kZV9zdGFuZGJ5LT53
YWl0X2Zvcl9yZXBsYXlfY2F0Y2h1cCgkbm9kZV9jYXNjYWRpbmdfc3RhbmRieSwgJG5vZGVf
cHJpbWFyeSk7CisKICMgY3JlYXRlIHRoZSBsb2dpY2FsIHNsb3RzIG9uIHRoZSBjYXNjYWRp
bmcgc3RhbmRieSB0b28KIGNyZWF0ZV9sb2dpY2FsX3Nsb3RzKCRub2RlX2Nhc2NhZGluZ19z
dGFuZGJ5LCAncHJvbW90aW9uXycpOwogCg==

--------------HRhWKLrD40wwLBspPWEZfzx5--