Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pqt67-00069X-I7 for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Apr 2023 10:07:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pqt65-00088D-2g for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Apr 2023 10:07:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pqt64-000884-Gj for pgsql-hackers@lists.postgresql.org; Mon, 24 Apr 2023 10:07:00 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pqt61-001bpg-8I for pgsql-hackers@lists.postgresql.org; Mon, 24 Apr 2023 10:06:59 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-3f09b4a156eso27470255e9.3 for ; Mon, 24 Apr 2023 03:06:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1682330815; x=1684922815; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=bilNE+ju2P4kjRlgPfGwD/x6QDdE2VBxiI0fOH/Y71s=; b=OyezWPI1D2g3s9AW8xBaRnhXhslDV2VrwNNOXexHaa3N2eVsN05+iLeUAMWP9UpZtt CyT+r3jo3b1rBUUt8FhD/wMxqnTbY9sJEW22JCShLCBu+kmbSu0O3r5w7IH1b9EpiKp4 72dVM6VXsf3NJnR7U2TxEp583QHnnKM5Fvcew8n+MkoAJiWXgXUXdRGKIYyw5rmqnUCI g45hgmhxO9lqGti7H7xiW59zdgAZQWGT22ThU6B65XW45Sn7XXc8IrZRpCRDFW/Jmw8G jnymkLoOuag7FDVUvSl8TqRcfL8C5nv2PQeUQS98q+xcNpJbvBTEsQgqEUHP2xbIk/1c 3beA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682330815; x=1684922815; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=bilNE+ju2P4kjRlgPfGwD/x6QDdE2VBxiI0fOH/Y71s=; b=e2S1iO8abwREw6tMqyUBgbNMsELjR26LoRw4386NQTQ472Molcpg5+OnDIkbaZmKjL vnOm0/cL5/qTiqcBBo8ubypbh8EafmkU3i9+pzmiVIC3N2eSa9RMX8ayh9vH47jKgPOv y1KONWMh292RuomlU457VPDQJNvZUfPmOK5qeSu58KOFuQPhjSlQV/DwIfXQIaZ6i/BA 2k77Gyeetx1fmn4vPba9t6kdCEdeZfAKLA9q2lWr2rCOffF1PI/SF+815kQ6F7fos1QM zZid9T7WApg6BctThtWD6nQm2hdg6bFzusCRw6xoSMDXa2ELIjGZyIVbuEjvjITo0305 wpmQ== X-Gm-Message-State: AAQBX9eQPKUzu1Yb4EUTvmKMafXr6bLHx2bpbe38sN1MhB5zCEoFbAyw wD0IJUC+RAtBGJBJQEgf4OQ= X-Google-Smtp-Source: AKy350bEqEO551mvwGP+Hkpb9VAi6UwaRX8GXXP3iVeZZKJcFkaf1HZEma3LiyTVU4ChywzDPyML8A== X-Received: by 2002:a05:600c:2212:b0:3f1:72ec:4024 with SMTP id z18-20020a05600c221200b003f172ec4024mr7099901wml.21.1682330815494; Mon, 24 Apr 2023 03:06:55 -0700 (PDT) Received: from [192.168.22.124] ([54.239.6.184]) by smtp.gmail.com with ESMTPSA id g9-20020a05600c000900b003f0aa490336sm15047193wmc.26.2023.04.24.03.06.54 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Apr 2023 03:06:54 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------Ueutl2qDReImqBqmSdzOLM53" Message-ID: Date: Mon, 24 Apr 2023 12:06:53 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: Add two missing tests in 035_standby_logical_decoding.pl Content-Language: en-US To: Amit Kapila Cc: vignesh C , PostgreSQL Hackers References: <2fefa454-5a70-2174-ddbf-4a0e41537139@gmail.com> <9ab1827c-9a57-8c48-59b2-c5fb62c21be3@gmail.com> From: "Drouvot, Bertrand" In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Ueutl2qDReImqBqmSdzOLM53 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi, On 4/24/23 8:24 AM, Amit Kapila wrote: > On Mon, Apr 24, 2023 at 11:24 AM Drouvot, Bertrand > wrote: >> > > Few comments: > ============ Thanks for looking at it! > 1. > +$node_subscriber->init(allows_streaming => 'logical'); > +$node_subscriber->append_conf('postgresql.conf', 'max_replication_slots = 4'); > > Why do we need slots on the subscriber? > Good point, it's not needed. I guess it has been missed during my initial patch clean up. Fixed in V3 attached. > 2. > +# Speed up the subscription creation > +$node_primary->safe_psql('postgres', "SELECT pg_log_standby_snapshot()"); > + > +# Explicitly shut down psql instance gracefully - to avoid hangs > +# or worse on windows > +$psql_subscriber{subscriber_stdin} .= "\\q\n"; > +$psql_subscriber{run}->finish; > + > +# Insert some rows on the primary > +$node_primary->safe_psql('postgres', > + qq[INSERT INTO tab_rep select generate_series(1,10);]); > + > +$node_primary->wait_for_replay_catchup($node_standby); > + > +# To speed up the wait_for_subscription_sync > +$node_primary->safe_psql('postgres', "SELECT pg_log_standby_snapshot()"); > +$node_subscriber->wait_for_subscription_sync($node_standby, 'tap_sub'); > > It is not clear to me why you need to do pg_log_standby_snapshot() twice. That's because there is 2 logical slot creations that have the be done on the standby. The one for the subscription: " CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') " And the one for the data sync: " CREATE_REPLICATION_SLOT "pg_16389_sync_16384_7225540800768250444" LOGICAL pgoutput (SNAPSHOT 'use') " Without the second "pg_log_standby_snapshot()" then wait_for_subscription_sync() would be waiting some time on the poll for "SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's');" Adding a comment in V3 to explain the need for the second pg_log_standby_snapshot(). > > 3. Why do you need $psql_subscriber to be used in a different way > instead of using safe_psql as is used for node_primary? > Because safe_psql() would wait for activity on the primary without being able to launch pg_log_standby_snapshot() on the primary while waiting. psql_subscriber() allows to not wait synchronously. Also adding a comment in V3 to explain why safe_psql() is not being used here. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com --------------Ueutl2qDReImqBqmSdzOLM53 Content-Type: text/plain; charset=UTF-8; name="v3-0002-Add-two-tests-in-035_standby_logical_decoding.pl.patch" Content-Disposition: attachment; filename*0="v3-0002-Add-two-tests-in-035_standby_logical_decoding.pl.pat"; filename*1="ch" Content-Transfer-Encoding: base64 RnJvbSBmNzRmYjk5ZmY2N2U0N2JiNzhiZGZmNjJiZGYxYWM4MjRhOGZiMjRiIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBCZXJ0cmFuZCBEcm91dm90IDxiZXJ0cmFuZGRyb3V2 b3QucGdAZ21haWwuY29tPgpEYXRlOiBNb24sIDI0IEFwciAyMDIzIDA1OjEzOjIzICswMDAw ClN1YmplY3Q6IFtQQVRDSCB2MyAyLzJdIEFkZCB0d28gdGVzdHMgaW4gMDM1X3N0YW5kYnlf bG9naWNhbF9kZWNvZGluZy5wbAoKQWRkaW5nIHR3byB0ZXN0cywgdG8gdmVyaWZ5IHRoYXQ6 CgotIHN1YnNjcmlidGlvbiB0byB0aGUgc3RhbmRieSBpcyBwb3NzaWJsZQotIGludmFsaWRh dGVkIGxvZ2ljYWwgc2xvdHMgZG8gbm90IGxlYWQgdG8gcmV0YWluaW5nIFdBTAotLS0KIHNy Yy90ZXN0L3BlcmwvUG9zdGdyZVNRTC9UZXN0L0NsdXN0ZXIucG0gICAgICB8ICAxMSArLQog Li4uL3QvMDM1X3N0YW5kYnlfbG9naWNhbF9kZWNvZGluZy5wbCAgICAgICAgIHwgMTY3ICsr KysrKysrKysrKysrKysrLQogMiBmaWxlcyBjaGFuZ2VkLCAxNzMgaW5zZXJ0aW9ucygrKSwg NSBkZWxldGlvbnMoLSkKICAgNC40JSBzcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdC8K ICA5NS41JSBzcmMvdGVzdC9yZWNvdmVyeS90LwoKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3Bl cmwvUG9zdGdyZVNRTC9UZXN0L0NsdXN0ZXIucG0gYi9zcmMvdGVzdC9wZXJsL1Bvc3RncmVT UUwvVGVzdC9DbHVzdGVyLnBtCmluZGV4IDZmN2Y0ZTVkZTQuLjgxOTY2N2Q0MmEgMTAwNjQ0 Ci0tLSBhL3NyYy90ZXN0L3BlcmwvUG9zdGdyZVNRTC9UZXN0L0NsdXN0ZXIucG0KKysrIGIv c3JjL3Rlc3QvcGVybC9Qb3N0Z3JlU1FML1Rlc3QvQ2x1c3Rlci5wbQpAQCAtMjY0NCw3ICsy NjQ0LDE2IEBAIHN1YiB3YWl0X2Zvcl9jYXRjaHVwCiAJfQogCWlmICghZGVmaW5lZCgkdGFy Z2V0X2xzbikpCiAJewotCQkkdGFyZ2V0X2xzbiA9ICRzZWxmLT5sc24oJ3dyaXRlJyk7CisJ CW15ICRpc3JlY292ZXJ5ID0gJHNlbGYtPnNhZmVfcHNxbCgncG9zdGdyZXMnLCAiU0VMRUNU IHBnX2lzX2luX3JlY292ZXJ5KCkiKTsKKwkJY2hvbXAoJGlzcmVjb3ZlcnkpOworCQlpZiAo JGlzcmVjb3ZlcnkgZXEgJ3QnKQorCQl7CisJCQkkdGFyZ2V0X2xzbiA9ICRzZWxmLT5sc24o J3JlcGxheScpOworCQl9CisJCWVsc2UKKwkJeworCQkJJHRhcmdldF9sc24gPSAkc2VsZi0+ bHNuKCd3cml0ZScpOworCQl9CiAJfQogCXByaW50ICJXYWl0aW5nIGZvciByZXBsaWNhdGlv biBjb25uICIKIAkgIC4gJHN0YW5kYnlfbmFtZSAuICIncyAiCmRpZmYgLS1naXQgYS9zcmMv dGVzdC9yZWNvdmVyeS90LzAzNV9zdGFuZGJ5X2xvZ2ljYWxfZGVjb2RpbmcucGwgYi9zcmMv dGVzdC9yZWNvdmVyeS90LzAzNV9zdGFuZGJ5X2xvZ2ljYWxfZGVjb2RpbmcucGwKaW5kZXgg YjhmNTMxMWZlOS4uNjQ3ZTIwM2IwZiAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVjb3Zlcnkv dC8wMzVfc3RhbmRieV9sb2dpY2FsX2RlY29kaW5nLnBsCisrKyBiL3NyYy90ZXN0L3JlY292 ZXJ5L3QvMDM1X3N0YW5kYnlfbG9naWNhbF9kZWNvZGluZy5wbApAQCAtOSwxMyArOSwxOSBA QCB1c2Ugd2FybmluZ3M7CiB1c2UgUG9zdGdyZVNRTDo6VGVzdDo6Q2x1c3RlcjsKIHVzZSBQ b3N0Z3JlU1FMOjpUZXN0OjpVdGlsczsKIHVzZSBUZXN0OjpNb3JlOwordXNlIFRpbWU6Okhp UmVzIHF3KHVzbGVlcCk7CiAKLW15ICgkc3RkaW4sICRzdGRvdXQsICRzdGRlcnIsICRjYXNj YWRpbmdfc3Rkb3V0LCAkY2FzY2FkaW5nX3N0ZGVyciwgJHJldCwgJGhhbmRsZSwgJHNsb3Qp OworbXkgKCRzdGRpbiwgICAgICAgICAgICAgJHN0ZG91dCwgICAgICAgICAgICAkc3RkZXJy LAorCSRjYXNjYWRpbmdfc3Rkb3V0LCAgJGNhc2NhZGluZ19zdGRlcnIsICAkc3Vic2NyaWJl cl9zdGRpbiwKKwkkc3Vic2NyaWJlcl9zdGRvdXQsICRzdWJzY3JpYmVyX3N0ZGVyciwgJHJl dCwKKwkkaGFuZGxlLCAgICAgICAgICAgICRzbG90KTsKIAogbXkgJG5vZGVfcHJpbWFyeSA9 IFBvc3RncmVTUUw6OlRlc3Q6OkNsdXN0ZXItPm5ldygncHJpbWFyeScpOwogbXkgJG5vZGVf c3RhbmRieSA9IFBvc3RncmVTUUw6OlRlc3Q6OkNsdXN0ZXItPm5ldygnc3RhbmRieScpOwog bXkgJG5vZGVfY2FzY2FkaW5nX3N0YW5kYnkgPSBQb3N0Z3JlU1FMOjpUZXN0OjpDbHVzdGVy LT5uZXcoJ2Nhc2NhZGluZ19zdGFuZGJ5Jyk7CitteSAkbm9kZV9zdWJzY3JpYmVyID0gUG9z dGdyZVNRTDo6VGVzdDo6Q2x1c3Rlci0+bmV3KCdzdWJzY3JpYmVyJyk7CiBteSAkZGVmYXVs dF90aW1lb3V0ID0gJFBvc3RncmVTUUw6OlRlc3Q6OlV0aWxzOjp0aW1lb3V0X2RlZmF1bHQ7 CitteSAkcHNxbF90aW1lb3V0ICAgID0gSVBDOjpSdW46OnRpbWVyKDIgKiAkZGVmYXVsdF90 aW1lb3V0KTsKIG15ICRyZXM7CiAKICMgTmFtZSBmb3IgdGhlIHBoeXNpY2FsIHNsb3Qgb24g cHJpbWFyeQpAQCAtMjY3LDcgKzI3Myw4IEBAICRub2RlX3N0YW5kYnktPmluaXRfZnJvbV9i YWNrdXAoCiAJaGFzX3N0cmVhbWluZyA9PiAxLAogCWhhc19yZXN0b3JpbmcgPT4gMSk7CiAk bm9kZV9zdGFuZGJ5LT5hcHBlbmRfY29uZigncG9zdGdyZXNxbC5jb25mJywKLQlxcVtwcmlt YXJ5X3Nsb3RfbmFtZSA9ICckcHJpbWFyeV9zbG90bmFtZSddKTsKKwlxcVtwcmltYXJ5X3Ns b3RfbmFtZSA9ICckcHJpbWFyeV9zbG90bmFtZScKKyAgICAgICBtYXhfcmVwbGljYXRpb25f c2xvdHMgPSA1XSk7CiAkbm9kZV9zdGFuZGJ5LT5zdGFydDsKICRub2RlX3ByaW1hcnktPndh aXRfZm9yX3JlcGxheV9jYXRjaHVwKCRub2RlX3N0YW5kYnkpOwogJG5vZGVfc3RhbmRieS0+ c2FmZV9wc3FsKCd0ZXN0ZGInLCBxcVtTRUxFQ1QgKiBGUk9NIHBnX2NyZWF0ZV9waHlzaWNh bF9yZXBsaWNhdGlvbl9zbG90KCckc3RhbmRieV9waHlzaWNhbF9zbG90bmFtZScpO10pOwpA QCAtMjg1LDYgKzI5MiwyNiBAQCAkbm9kZV9jYXNjYWRpbmdfc3RhbmRieS0+YXBwZW5kX2Nv bmYoJ3Bvc3RncmVzcWwuY29uZicsCiAkbm9kZV9jYXNjYWRpbmdfc3RhbmRieS0+c3RhcnQ7 CiAkbm9kZV9zdGFuZGJ5LT53YWl0X2Zvcl9yZXBsYXlfY2F0Y2h1cCgkbm9kZV9jYXNjYWRp bmdfc3RhbmRieSwgJG5vZGVfcHJpbWFyeSk7CiAKKyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj CisjIEluaXRpYWxpemUgc3Vic2NyaWJlciBub2RlCisjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IworJG5vZGVfc3Vic2NyaWJlci0+aW5pdChhbGxvd3Nfc3RyZWFtaW5nID0+ICdsb2dpY2Fs Jyk7Ciskbm9kZV9zdWJzY3JpYmVyLT5zdGFydDsKKworbXkgJXBzcWxfc3Vic2NyaWJlciA9 ICgKKwknc3Vic2NyaWJlcl9zdGRpbicgID0+ICcnLAorCSdzdWJzY3JpYmVyX3N0ZG91dCcg PT4gJycsCisJJ3N1YnNjcmliZXJfc3RkZXJyJyA9PiAnJyk7CiskcHNxbF9zdWJzY3JpYmVy e3J1bn0gPSBJUEM6OlJ1bjo6c3RhcnQoCisJWyAncHNxbCcsICctWEEnLCAnLWYnLCAnLScs ICctZCcsICRub2RlX3N1YnNjcmliZXItPmNvbm5zdHIoJ3Bvc3RncmVzJykgXSwKKwknPCcs CisJXCRwc3FsX3N1YnNjcmliZXJ7c3Vic2NyaWJlcl9zdGRpbn0sCisJJz4nLAorCVwkcHNx bF9zdWJzY3JpYmVye3N1YnNjcmliZXJfc3Rkb3V0fSwKKwknMj4nLAorCVwkcHNxbF9zdWJz Y3JpYmVye3N1YnNjcmliZXJfc3RkZXJyfSwKKwkkcHNxbF90aW1lb3V0KTsKKwogIyMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMKICMgVGVzdCB0 aGF0IGxvZ2ljYWwgZGVjb2Rpbmcgb24gdGhlIHN0YW5kYnkKICMgYmVoYXZlcyBjb3JyZWN0 bHkuCkBAIC0zNjUsNiArMzkyLDY1IEBAIGlzKCAkbm9kZV9wcmltYXJ5LT5wc3FsKAogICAg IDMsCiAgICAgJ3JlcGxheWluZyBsb2dpY2FsIHNsb3QgZnJvbSBhbm90aGVyIGRhdGFiYXNl IGZhaWxzJyk7CiAKKyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIyMjCisjIFRlc3QgdGhhdCB3ZSBjYW4gc3Vic2NyaWJlIG9uIHRoZSBzdGFuZGJ5 IHdpdGggdGhlIHB1YmxpY2F0aW9uCisjIGNyZWF0ZWQgb24gdGhlIHByaW1hcnkuCisjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIworCisjIENy ZWF0ZSBhIHRhYmxlIG9uIHRoZSBwcmltYXJ5Ciskbm9kZV9wcmltYXJ5LT5zYWZlX3BzcWwo J3Bvc3RncmVzJywKKwkiQ1JFQVRFIFRBQkxFIHRhYl9yZXAgKGEgaW50IHByaW1hcnkga2V5 KSIpOworCisjIENyZWF0ZSBhIHRhYmxlIChzYW1lIHN0cnVjdHVyZSkgb24gdGhlIHN1YnNj cmliZXIgbm9kZQorJG5vZGVfc3Vic2NyaWJlci0+c2FmZV9wc3FsKCdwb3N0Z3JlcycsCisJ IkNSRUFURSBUQUJMRSB0YWJfcmVwIChhIGludCBwcmltYXJ5IGtleSkiKTsKKworIyBDcmVh dGUgYSBwdWJsaWNhdGlvbiBvbiB0aGUgcHJpbWFyeQorJG5vZGVfcHJpbWFyeS0+c2FmZV9w c3FsKCdwb3N0Z3JlcycsCisJIkNSRUFURSBQVUJMSUNBVElPTiB0YXBfcHViIGZvciB0YWJs ZSB0YWJfcmVwIik7CisKKyMgU3Vic2NyaWJlIG9uIHRoZSBzdGFuZGJ5CitteSAkc3RhbmRi eV9jb25uc3RyID0gJG5vZGVfc3RhbmRieS0+Y29ubnN0ciAuICcgZGJuYW1lPXBvc3RncmVz JzsKKworIyBOb3QgdXNpbmcgc2FmZV9wc3FsKCkgaGVyZSBhcyBpdCB3b3VsZCB3YWl0IGZv ciBhY3Rpdml0eSBvbiB0aGUgcHJpbWFyeQorIyB3aXRob3V0IGJlaW5nIGFibGUgdG8gbGF1 bmNoIHBnX2xvZ19zdGFuZGJ5X3NuYXBzaG90KCkgb24gdGhlIHByaW1hcnkgd2hpbGUKKyMg d2FpdGluZy4KKyMgcHNxbF9zdWJzY3JpYmVyKCkgYWxsb3dzIHRvIG5vdCB3YWl0IHN5bmNo cm9ub3VzbHkuCiskcHNxbF9zdWJzY3JpYmVye3N1YnNjcmliZXJfc3RkaW59IC49CisgIHFx W0NSRUFURSBTVUJTQ1JJUFRJT04gdGFwX3N1YiBDT05ORUNUSU9OICckc3RhbmRieV9jb25u c3RyJyBQVUJMSUNBVElPTiB0YXBfcHViO107CiskcHNxbF9zdWJzY3JpYmVye3N1YnNjcmli ZXJfc3RkaW59IC49ICJcbiI7CisKKyRwc3FsX3N1YnNjcmliZXJ7cnVufS0+cHVtcF9uYigp OworCisjIFNwZWVkIHVwIHRoZSBzdWJzY3JpcHRpb24gY3JlYXRpb24KKyRub2RlX3ByaW1h cnktPnNhZmVfcHNxbCgncG9zdGdyZXMnLCAiU0VMRUNUIHBnX2xvZ19zdGFuZGJ5X3NuYXBz aG90KCkiKTsKKworIyBFeHBsaWNpdGx5IHNodXQgZG93biBwc3FsIGluc3RhbmNlIGdyYWNl ZnVsbHkgLSB0byBhdm9pZCBoYW5ncworIyBvciB3b3JzZSBvbiB3aW5kb3dzCiskcHNxbF9z dWJzY3JpYmVye3N1YnNjcmliZXJfc3RkaW59IC49ICJcXHFcbiI7CiskcHNxbF9zdWJzY3Jp YmVye3J1bn0tPmZpbmlzaDsKKworIyBJbnNlcnQgc29tZSByb3dzIG9uIHRoZSBwcmltYXJ5 Ciskbm9kZV9wcmltYXJ5LT5zYWZlX3BzcWwoJ3Bvc3RncmVzJywKKwlxcVtJTlNFUlQgSU5U TyB0YWJfcmVwIHNlbGVjdCBnZW5lcmF0ZV9zZXJpZXMoMSwxMCk7XSk7CisKKyRub2RlX3By aW1hcnktPndhaXRfZm9yX3JlcGxheV9jYXRjaHVwKCRub2RlX3N0YW5kYnkpOworCisjIFRv IHNwZWVkIHVwIHRoZSB3YWl0X2Zvcl9zdWJzY3JpcHRpb25fc3luYworIyBJbmRlZWQgYSBz ZWNvbmQgbG9naWNhbCBzbG90IChwZ18lc3luYyU6IGV4YWN0IG5hbWUgY29taW5nIGZyb20g UmVwbGljYXRpb25TbG90TmFtZUZvclRhYmxlc3luYygpKQorIyBpcyBjcmVhdGVkIHVuZGVy IHRoZSBob29kIG9uIHRoZSBzdGFuZGJ5IGZvciB0aGUgZGF0YSBzeW5jCiskbm9kZV9wcmlt YXJ5LT5zYWZlX3BzcWwoJ3Bvc3RncmVzJywgIlNFTEVDVCBwZ19sb2dfc3RhbmRieV9zbmFw c2hvdCgpIik7Ciskbm9kZV9zdWJzY3JpYmVyLT53YWl0X2Zvcl9zdWJzY3JpcHRpb25fc3lu Yygkbm9kZV9zdGFuZGJ5LCAndGFwX3N1YicpOworCisjIENoZWNrIHRoYXQgdGhlIHN1YnNj cmliZXIgY2FuIHNlZSB0aGUgcm93cyBpbnNlcnRlZCBpbiB0aGUgcHJpbWFyeQorJHJlc3Vs dCA9CisgICRub2RlX3N1YnNjcmliZXItPnNhZmVfcHNxbCgncG9zdGdyZXMnLCAiU0VMRUNU IGNvdW50KCopIEZST00gdGFiX3JlcCIpOworaXMoJHJlc3VsdCwgcXEoMTApLCAnY2hlY2sg cmVwbGljYXRlZCBpbnNlcnRzIGFmdGVyIHN1YnNjcmlwdGlvbiBvbiBzdGFuZGJ5Jyk7CisK KyMgV2UgZG8gbm90IG5lZWQgdGhlIHN1YnNjcmlwdGlvbiBhbmQgdGhlIHN1YnNjcmliZXIg YW55bW9yZQorJG5vZGVfc3Vic2NyaWJlci0+c2FmZV9wc3FsKCdwb3N0Z3JlcycsICJEUk9Q IFNVQlNDUklQVElPTiB0YXBfc3ViIik7Ciskbm9kZV9zdWJzY3JpYmVyLT5zdG9wOworCiAj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIwogIyBS ZWNvdmVyeSBjb25mbGljdDogSW52YWxpZGF0ZSBjb25mbGljdGluZyBzbG90cywgaW5jbHVk aW5nIGluLXVzZSBzbG90cwogIyBTY2VuYXJpbyAxOiBob3Rfc3RhbmRieV9mZWVkYmFjayBv ZmYgYW5kIHZhY3V1bSBGVUxMCkBAIC00MDgsOSArNDk0LDgyIEBAICRub2RlX3N0YW5kYnkt PnJlc3RhcnQ7CiBjaGVja19zbG90c19jb25mbGljdGluZ19zdGF0dXMoMSk7CiAKICMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjCi0jIFZlcmlm eSB0aGF0IGludmFsaWRhdGVkIGxvZ2ljYWwgc2xvdHMgZG8gbm90IGxlYWQgdG8gcmV0YWlu aW5nIFdBTAorIyBWZXJpZnkgdGhhdCBpbnZhbGlkYXRlZCBsb2dpY2FsIHNsb3RzIGRvIG5v dCBsZWFkIHRvIHJldGFpbmluZyBXQUwuCiAjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIwotIyBYWFhYWCBUT0RPCisKKyMgR2V0IHRoZSByZXN0 YXJ0X2xzbiBmcm9tIGFuIGludmFsaWRhdGVkIHNsb3QKK215ICRyZXN0YXJ0X2xzbiA9ICRu b2RlX3N0YW5kYnktPnNhZmVfcHNxbCgncG9zdGdyZXMnLAorCSJTRUxFQ1QgcmVzdGFydF9s c24gZnJvbSBwZ19yZXBsaWNhdGlvbl9zbG90cyBXSEVSRSBzbG90X25hbWUgPSAndmFjdXVt X2Z1bGxfYWN0aXZlc2xvdCcgYW5kIGNvbmZsaWN0aW5nIGlzIHRydWU7IgorKTsKKworY2hv bXAoJHJlc3RhcnRfbHNuKTsKKworIyBHZXQgdGhlIFdBTCBmaWxlIG5hbWUgYXNzb2NpYXRl ZCB0byB0aGlzIGxzbiBvbiB0aGUgcHJpbWFyeQorbXkgJHdhbGZpbGVfbmFtZSA9ICRub2Rl X3ByaW1hcnktPnNhZmVfcHNxbCgncG9zdGdyZXMnLAorCSJTRUxFQ1QgcGdfd2FsZmlsZV9u YW1lKCckcmVzdGFydF9sc24nKSIpOworCitjaG9tcCgkd2FsZmlsZV9uYW1lKTsKKworIyBD aGVjayB0aGUgV0FMIGZpbGUgaXMgc3RpbGwgb24gdGhlIHByaW1hcnkKK29rKC1mICRub2Rl X3ByaW1hcnktPmRhdGFfZGlyIC4gJy9wZ193YWwvJyAuICR3YWxmaWxlX25hbWUsCisJIldB TCBmaWxlIHN0aWxsIG9uIHRoZSBwcmltYXJ5Iik7CisKKyMgR2V0IHRoZSBudW1iZXIgb2Yg V0FMIGZpbGVzIG9uIHRoZSBzdGFuZGJ5CitteSAkbmJfc3RhbmRieV9maWxlcyA9ICRub2Rl X3N0YW5kYnktPnNhZmVfcHNxbCgncG9zdGdyZXMnLAorCSJTRUxFQ1QgQ09VTlQoKikgRlJP TSBwZ19sc19kaXIoJ3BnX3dhbCcpIik7CisKK2Nob21wKCRuYl9zdGFuZGJ5X2ZpbGVzKTsK KworIyBTd2l0Y2ggV0FMIGZpbGVzIG9uIHRoZSBwcmltYXJ5CitteSBAYyA9ICgxIC4uICRu Yl9zdGFuZGJ5X2ZpbGVzKTsKKworJG5vZGVfcHJpbWFyeS0+c2FmZV9wc3FsKCdwb3N0Z3Jl cycsICJjcmVhdGUgdGFibGUgcmV0YWluX3Rlc3QoYSBpbnQpIik7CisKK2ZvciAoQGMpCit7 CisJJG5vZGVfcHJpbWFyeS0+c2FmZV9wc3FsKAorCQkncG9zdGdyZXMnLCAiU0VMRUNUIHBn X3N3aXRjaF93YWwoKTsKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIGluc2VydCBpbnRvIHJldGFpbl90ZXN0IHZhbHVlcygiCisJCSAgLiAkXyAuICIpOyIp OworfQorCisjIEFzayBmb3IgYSBjaGVja3BvaW50Ciskbm9kZV9wcmltYXJ5LT5zYWZlX3Bz cWwoJ3Bvc3RncmVzJywgJ2NoZWNrcG9pbnQ7Jyk7CisKKyMgQ2hlY2sgdGhhdCB0aGUgV0FM IGZpbGUgaGFzIG5vdCBiZWVuIHJldGFpbmVkIG9uIHRoZSBwcmltYXJ5CitvayghLWYgJG5v ZGVfcHJpbWFyeS0+ZGF0YV9kaXIgLiAnL3BnX3dhbC8nIC4gJHdhbGZpbGVfbmFtZSwKKwki V0FMIGZpbGUgbm90IG9uIHRoZSBwcmltYXJ5IGFueW1vcmUiKTsKKworIyBXYWl0IGZvciB0 aGUgc3RhbmRieSB0byBjYXRjaCB1cAorJG5vZGVfcHJpbWFyeS0+d2FpdF9mb3JfY2F0Y2h1 cCgkbm9kZV9zdGFuZGJ5KTsKKworIyBHZW5lcmF0ZSBhbm90aGVyIFdBTCBzd2l0Y2gsIG1v cmUgYWN0aXZpdHkgYW5kIGEgY2hlY2twb2ludAorJG5vZGVfcHJpbWFyeS0+c2FmZV9wc3Fs KAorCSdwb3N0Z3JlcycsICJTRUxFQ1QgcGdfc3dpdGNoX3dhbCgpOworICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBpbnNlcnQgaW50byByZXRhaW5fdGVzdCB2 YWx1ZXMoMSk7Iik7Ciskbm9kZV9wcmltYXJ5LT5zYWZlX3BzcWwoJ3Bvc3RncmVzJywgJ2No ZWNrcG9pbnQ7Jyk7CisKKyMgV2FpdCBmb3IgdGhlIHN0YW5kYnkgdG8gY2F0Y2ggdXAKKyRu b2RlX3ByaW1hcnktPndhaXRfZm9yX2NhdGNodXAoJG5vZGVfc3RhbmRieSk7CisKKyMgVmVy aWZ5IHRoYXQgdGhlIHdhbCBmaWxlIGhhcyBub3QgYmVlbiByZXRhaW5lZCBvbiB0aGUgc3Rh bmRieQorbXkgJHN0YW5kYnlfd2FsZmlsZSA9ICRub2RlX3N0YW5kYnktPmRhdGFfZGlyIC4g Jy9wZ193YWwvJyAuICR3YWxmaWxlX25hbWU7CisKKyMgV2UgY2FuIG5vdCB0ZXN0IGlmIHRo ZSBXQUwgZmlsZSBzdGlsbCBleGlzdHMgaW1tZWRpYXRlbHkuCisjIFdlIG5lZWQgdG8gbGV0 IHNvbWUgdGltZSB0byB0aGUgc3RhbmRieSB0byBhY3R1YWxseSAicmVtb3ZlIiBpdC4KK215 ICRpID0gMDsKK3doaWxlICgxKQoreworCWxhc3QgaWYgIS1mICRzdGFuZGJ5X3dhbGZpbGU7 CisJaWYgKCRpKysgPT0gMTAgKiAkZGVmYXVsdF90aW1lb3V0KQorCXsKKwkJZGllCisJCSAg ImNvdWxkIG5vdCBkZXRlcm1pbmUgaWYgV0FMIGZpbGUgaGFzIGJlZW4gcmV0YWluZWQgb3Ig bm90LCBjYW4ndCBjb250aW51ZSI7CisJfQorCXVzbGVlcCgxMDBfMDAwKTsKK30KKworb2so MSwgImludmFsaWRhdGVkIGxvZ2ljYWwgc2xvdHMgZG8gbm90IGxlYWQgdG8gcmV0YWluaW5n IFdBTCIpOwogCiAjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIwogIyBSZWNvdmVyeSBjb25mbGljdDogSW52YWxpZGF0ZSBjb25mbGljdGluZyBz bG90cywgaW5jbHVkaW5nIGluLXVzZSBzbG90cwotLSAKMi4zNC4xCgo= --------------Ueutl2qDReImqBqmSdzOLM53 Content-Type: text/plain; charset=UTF-8; name="v3-0001-Lower-log-level-in-035_standby_logical_decoding.p.patch" Content-Disposition: attachment; filename*0="v3-0001-Lower-log-level-in-035_standby_logical_decoding.p.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSBkYmJlMTllOGJlYzRlNjY0ZjhlMmQ3MDkzMjA4YmVkMWU2ZjU3ZTMxIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBCZXJ0cmFuZCBEcm91dm90IDxiZXJ0cmFuZGRyb3V2 b3QucGdAZ21haWwuY29tPgpEYXRlOiBNb24sIDI0IEFwciAyMDIzIDA1OjEwOjUzICswMDAw ClN1YmplY3Q6IFtQQVRDSCB2MyAxLzJdIExvd2VyIGxvZyBsZXZlbCBpbiAwMzVfc3RhbmRi eV9sb2dpY2FsX2RlY29kaW5nLnBsCgpMb3dlciBsb2cgbGV2ZWwgaW4gMDM1X3N0YW5kYnlf bG9naWNhbF9kZWNvZGluZy5wbCB0byBzaHJpbmsgdGhlIG91dHB1dCBzaXplCmFuZCBzcGVl ZCB1cCB0aGUgdGVzdCBhIGJpdC4KLS0tCiBzcmMvdGVzdC9yZWNvdmVyeS90LzAzNV9zdGFu ZGJ5X2xvZ2ljYWxfZGVjb2RpbmcucGwgfCAyIC0tCiAxIGZpbGUgY2hhbmdlZCwgMiBkZWxl dGlvbnMoLSkKIDEwMC4wJSBzcmMvdGVzdC9yZWNvdmVyeS90LwoKZGlmZiAtLWdpdCBhL3Ny Yy90ZXN0L3JlY292ZXJ5L3QvMDM1X3N0YW5kYnlfbG9naWNhbF9kZWNvZGluZy5wbCBiL3Ny Yy90ZXN0L3JlY292ZXJ5L3QvMDM1X3N0YW5kYnlfbG9naWNhbF9kZWNvZGluZy5wbAppbmRl eCAyMDgzOGQ0OWI1Li5iOGY1MzExZmU5IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWNvdmVy eS90LzAzNV9zdGFuZGJ5X2xvZ2ljYWxfZGVjb2RpbmcucGwKKysrIGIvc3JjL3Rlc3QvcmVj b3ZlcnkvdC8wMzVfc3RhbmRieV9sb2dpY2FsX2RlY29kaW5nLnBsCkBAIC0yMzUsOCArMjM1 LDYgQEAgJG5vZGVfcHJpbWFyeS0+YXBwZW5kX2NvbmYoJ3Bvc3RncmVzcWwuY29uZicsIHF7 CiB3YWxfbGV2ZWwgPSAnbG9naWNhbCcKIG1heF9yZXBsaWNhdGlvbl9zbG90cyA9IDQKIG1h eF93YWxfc2VuZGVycyA9IDQKLWxvZ19taW5fbWVzc2FnZXMgPSAnZGVidWcyJwotbG9nX2Vy cm9yX3ZlcmJvc2l0eSA9IHZlcmJvc2UKIH0pOwogJG5vZGVfcHJpbWFyeS0+ZHVtcF9pbmZv OwogJG5vZGVfcHJpbWFyeS0+c3RhcnQ7Ci0tIAoyLjM0LjEKCg== --------------Ueutl2qDReImqBqmSdzOLM53--