Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wFd68-005NR8-1h for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Apr 2026 19:18:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wFd67-00Eumf-1w for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Apr 2026 19:18:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wFd67-00EumU-02 for pgsql-hackers@lists.postgresql.org; Wed, 22 Apr 2026 19:18:55 +0000 Received: from mail-dy1-x132d.google.com ([2607:f8b0:4864:20::132d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wFd64-00000002IYu-0FmO for pgsql-hackers@postgresql.org; Wed, 22 Apr 2026 19:18:53 +0000 Received: by mail-dy1-x132d.google.com with SMTP id 5a478bee46e88-2d868d014a5so5675809eec.1 for ; Wed, 22 Apr 2026 12:18:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20251104.gappssmtp.com; s=20251104; t=1776885531; x=1777490331; darn=postgresql.org; h=mime-version:user-agent:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to; bh=DGSS4vKSAuS7m9GXhrFwP/n77o/RNIUExdbP4J0RsZ4=; b=T67T/EB9J2OPIOJmH6ON+oMMqlsMKL45oZNTrNV/TTtAYkCMRnOce4cOod9TpqA6Nl JGT+qW6C4WCOf6OKiCnJo3jSP3fFpiBo2ld7MGxQaAR9Alz4yUoc7VF0XyFcYb31fyGw Z1sRFhe16VwSU3hFvJZACkyWnajg8YLG4dg7SnINT4BpQ+VuafjNTpcrzxcgHNVW02VL LDeKc9tG/DyE/p2SVx8r2yQfnOXqNq1mI0bMPRfQGGvkYrV+gbHgxcj/aJmNGXQOMXVZ zTWxE1BRLiIduApn4FsmeXKw2OGj61VFTFR/bLZKMdcFDZbbVZyd6kWKqHDpruSTI8VV iqPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776885531; x=1777490331; h=mime-version:user-agent:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=DGSS4vKSAuS7m9GXhrFwP/n77o/RNIUExdbP4J0RsZ4=; b=IILJfFDExKA+cIloVMFXwTx2WlMHECXPOX3b/xEReHqOFlVRiqpGd8kzAsxXFSidXj U0nz8sjQtHiyX8Ykve0BGNuNn9vC+0axCyAM7ZYchKrEUh9jjYJgqJnnKCm3QsLSVGC1 jMkq5w9Iif28b4hLaH79y8hV9JI1qMlun3gPQYpgMGMHc5wjoXo9wr6j2+EdiNZDuNY7 oZHOVRhxDZbGtrQBIwvDqQ1U/bGSqg3hLyeODaY8w75H3hwrpzNwBCIKgdhLDCDPk4u1 1UUkkG93ofm1deHxfKPrZB6Um4BT0t+PIM25Qe+s+Lo4qZN64f74REbdmnuCA+4NJGJH ILoQ== X-Gm-Message-State: AOJu0YxgPGJPDacswTc8bCw0wSdnlCENB806ag+vNk8HpdMW8qdxSvaZ AYiZ1uqBKhLtZeUcUYhMSoQinSXSZ7AvHou9n0pA7pVwVdN86kDo2EesBXaLHn7pOnPEfu+1HcQ BAH0= X-Gm-Gg: AeBDiev1LlDemLaIsd9+Qz+9SymEoUpUKXywwggI2i+wG5iLXWg20PpxKy5hn5sn6Ka ZHRGBBruZqEXVFMgA800KJmeoBGSgio/jLHq0XbHQ6VFXASjH8V3fjsRVcaLtViemrdaKZbagya p9p7Wr4b4EetpksvGOn6S8Mz+NexK4g9PpoJ3BU5akhg9ourRyHigvFXUfogWce0DKlA8YMJoMX W2SsdU2wmy+UUTJuYfFlVE+ZilNtLmcJiAQm2AmhCUWk14LR9YcL8kWEqqzg0rpYZr5mAh3U2hZ +l0aM4hcckhPYIpszyXB61tLyG/wkpU4+PRbbj6HhgzVSIdWB3htcTBg0438m71BGrp+UA7p2FH wCkXE9fAFH7qHaQsEEhB9kHHXONDyjKR86ohlNntSqyLnHvT2XueppClo2kGyE9VHSHdKGaoQCN yEhiDJHKk3XMLoNmp9aWHFWCBQ4laFKC9ySA== X-Received: by 2002:a05:7300:cca7:b0:2e6:e504:abc6 with SMTP id 5a478bee46e88-2e6e504cebcmr6050925eec.0.1776885531162; Wed, 22 Apr 2026 12:18:51 -0700 (PDT) Received: from [10.10.246.112] ([12.63.242.122]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2e53d2cfd3esm24246133eec.21.2026.04.22.12.18.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 22 Apr 2026 12:18:50 -0700 (PDT) Message-ID: Subject: GUC parameter ACLs and physical walsender From: Jeff Davis To: pgsql-hackers@postgresql.org Cc: Andrey Borodin , Mark Dilger Date: Wed, 22 Apr 2026 12:18:48 -0700 Content-Type: multipart/mixed; boundary="=-5aZHONW8ukzB/0hPIJ9F" User-Agent: Evolution 3.52.3-0ubuntu1.1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-5aZHONW8ukzB/0hPIJ9F Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Moving discussion from: https://www.postgresql.org/message-id/4524ed61a015d3496fc008644dcb999bb3191= 6a7.camel@j-davis.com because this is a separate issue. If you specify a SUSET GUC setting when connecting as non-superuser for physical replication: PGOPTIONS=3D"-c wal_compression=3Don" \ pg_receivewal -D archive -U repl you get: FATAL: cannot read pg_class without having selected a database but only if you connect immediately after the server starts. If you do something else first, like an ordinary connection and "SELECT 1", and then start the replication connection, you get (after commit dbf217c1c7): FATAL: permission denied to set parameter "wal_compression" as expected. The problem goes back to a0ffa885e47. It seems to be because pg_parameter_acl is not nailed in cache. I attached a quick patch to do so (which turns it into the "expected permission denied" error). But I'm not sure if that's the right fix, or if it would be a complete fix. I also don't think that would be backportable, but perhaps? Regards, Jeff Davis --=-5aZHONW8ukzB/0hPIJ9F Content-Disposition: attachment; filename="v1-0001-Nail-pg_parameter_acl-in-relcache.patch" Content-Type: text/x-patch; name="v1-0001-Nail-pg_parameter_acl-in-relcache.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSA1Y2YyMDA4MWRlNTE3MmVjOWExZDc2OGIwNTg0ZDQwYmZiZjljYjEyIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWZmIERhdmlzIDxqZWZmQGotZGF2aXMuY29tPgpEYXRlOiBX ZWQsIDIyIEFwciAyMDI2IDExOjUwOjEyIC0wNzAwClN1YmplY3Q6IFtQQVRDSCB2MV0gTmFpbCBw Z19wYXJhbWV0ZXJfYWNsIGluIHJlbGNhY2hlLgoKUHJldmlvdXNseSwgYSBwYXJhbWV0ZXIgc3Bl Y2lmaWVkIGluIHRoZSBzdGFydHVwIHBhY2tldCBmb3IgYSBwaHlzaWNhbApyZXBsaWNhdGlvbiBj b25uZWN0aW9uIGNvdWxkIGVuY291bnRlciBhbiBlcnJvciB0cnlpbmcgdG8gcGVyZm9ybSBhbgpB Q0wgY2hlY2sgZm9yIHRoZSBzZXR0aW5nLgotLS0KIHNyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL2Nh dGNhY2hlLmMgICAgIHwgIDIgKysKIHNyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL3JlbGNhY2hlLmMg ICAgIHwgMTkgKysrKysrKysrKysrKystLS0tLQogc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wYXJh bWV0ZXJfYWNsLmggfCAgMiArLQogMyBmaWxlcyBjaGFuZ2VkLCAxNyBpbnNlcnRpb25zKCspLCA2 IGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL2NhdGNh Y2hlLmMgYi9zcmMvYmFja2VuZC91dGlscy9jYWNoZS9jYXRjYWNoZS5jCmluZGV4IGE4ZTdiZjY0 OWQyLi42ZmIzNWRlZGY5NSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUvY2F0 Y2FjaGUuYworKysgYi9zcmMvYmFja2VuZC91dGlscy9jYWNoZS9jYXRjYWNoZS5jCkBAIC0xMzM1 LDYgKzEzMzUsOCBAQCBJbmRleFNjYW5PSyhDYXRDYWNoZSAqY2FjaGUpCiAJCWNhc2UgQVVUSE9J RDoKIAkJY2FzZSBBVVRITUVNTUVNUk9MRToKIAkJY2FzZSBEQVRBQkFTRU9JRDoKKwkJY2FzZSBQ QVJBTUVURVJBQ0xOQU1FOgorCQljYXNlIFBBUkFNRVRFUkFDTE9JRDoKIAogCQkJLyoKIAkJCSAq IFByb3RlY3QgYXV0aGVudGljYXRpb24gbG9va3VwcyBvY2N1cnJpbmcgYmVmb3JlIHJlbGNhY2hl IGhhcwpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUvcmVsY2FjaGUuYyBiL3Ny Yy9iYWNrZW5kL3V0aWxzL2NhY2hlL3JlbGNhY2hlLmMKaW5kZXggZTE5ZjBkM2U1MWMuLjEwZDQ4 MTUxOGViIDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5jCisr KyBiL3NyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL3JlbGNhY2hlLmMKQEAgLTU2LDYgKzU2LDcgQEAK ICNpbmNsdWRlICJjYXRhbG9nL3BnX3Byb2MuaCIKICNpbmNsdWRlICJjYXRhbG9nL3BnX3B1Ymxp Y2F0aW9uLmgiCiAjaW5jbHVkZSAiY2F0YWxvZy9wZ19yZXdyaXRlLmgiCisjaW5jbHVkZSAiY2F0 YWxvZy9wZ19wYXJhbWV0ZXJfYWNsLmgiCiAjaW5jbHVkZSAiY2F0YWxvZy9wZ19zaHNlY2xhYmVs LmgiCiAjaW5jbHVkZSAiY2F0YWxvZy9wZ19zdGF0aXN0aWNfZXh0LmgiCiAjaW5jbHVkZSAiY2F0 YWxvZy9wZ19zdWJzY3JpcHRpb24uaCIKQEAgLTEyMCw2ICsxMjEsNyBAQCBzdGF0aWMgY29uc3Qg Rm9ybURhdGFfcGdfYXR0cmlidXRlIERlc2NfcGdfYXV0aF9tZW1iZXJzW05hdHRzX3BnX2F1dGhf bWVtYmVyc10gPQogc3RhdGljIGNvbnN0IEZvcm1EYXRhX3BnX2F0dHJpYnV0ZSBEZXNjX3BnX2lu ZGV4W05hdHRzX3BnX2luZGV4XSA9IHtTY2hlbWFfcGdfaW5kZXh9Owogc3RhdGljIGNvbnN0IEZv cm1EYXRhX3BnX2F0dHJpYnV0ZSBEZXNjX3BnX3Noc2VjbGFiZWxbTmF0dHNfcGdfc2hzZWNsYWJl bF0gPSB7U2NoZW1hX3BnX3Noc2VjbGFiZWx9Owogc3RhdGljIGNvbnN0IEZvcm1EYXRhX3BnX2F0 dHJpYnV0ZSBEZXNjX3BnX3N1YnNjcmlwdGlvbltOYXR0c19wZ19zdWJzY3JpcHRpb25dID0ge1Nj aGVtYV9wZ19zdWJzY3JpcHRpb259Oworc3RhdGljIGNvbnN0IEZvcm1EYXRhX3BnX2F0dHJpYnV0 ZSBEZXNjX3BnX3BhcmFtZXRlcl9hY2xbTmF0dHNfcGdfcGFyYW1ldGVyX2FjbF0gPSB7U2NoZW1h X3BnX3BhcmFtZXRlcl9hY2x9OwogCiAvKgogICoJCUhhc2ggdGFibGVzIHRoYXQgaW5kZXggdGhl IHJlbGF0aW9uIGNhY2hlCkBAIC00MDc0LDggKzQwNzYsMTAgQEAgUmVsYXRpb25DYWNoZUluaXRp YWxpemVQaGFzZTIodm9pZCkKIAkJCQkgIE5hdHRzX3BnX3Noc2VjbGFiZWwsIERlc2NfcGdfc2hz ZWNsYWJlbCk7CiAJCWZvcm1yZGVzYygicGdfc3Vic2NyaXB0aW9uIiwgU3Vic2NyaXB0aW9uUmVs YXRpb25fUm93dHlwZV9JZCwgdHJ1ZSwKIAkJCQkgIE5hdHRzX3BnX3N1YnNjcmlwdGlvbiwgRGVz Y19wZ19zdWJzY3JpcHRpb24pOworCQlmb3JtcmRlc2MoInBnX3BhcmFtZXRlcl9hY2wiLCBQYXJh bWV0ZXJBY2xSZWxhdGlvbl9Sb3d0eXBlX0lkLCB0cnVlLAorCQkJCSAgTmF0dHNfcGdfcGFyYW1l dGVyX2FjbCwgRGVzY19wZ19wYXJhbWV0ZXJfYWNsKTsKIAotI2RlZmluZSBOVU1fQ1JJVElDQUxf U0hBUkVEX1JFTFMJNQkvKiBmaXggaWYgeW91IGNoYW5nZSBsaXN0IGFib3ZlICovCisjZGVmaW5l IE5VTV9DUklUSUNBTF9TSEFSRURfUkVMUwk2CS8qIGZpeCBpZiB5b3UgY2hhbmdlIGxpc3QgYWJv dmUgKi8KIAl9CiAKIAlNZW1vcnlDb250ZXh0U3dpdGNoVG8ob2xkY3h0KTsKQEAgLTQxOTYsOSAr NDIwMCwxMCBAQCBSZWxhdGlvbkNhY2hlSW5pdGlhbGl6ZVBoYXNlMyh2b2lkKQogCSAqIG5vbi1z aGFyZWQgY2F0YWxvZ3MgYXQgYWxsLiAgQXV0b3ZhY3V1bSBjYWxscyBJbml0UG9zdGdyZXMgd2l0 aCBhCiAJICogZGF0YWJhc2UgT0lELCBzbyBpdCBpbnN0ZWFkIGRlcGVuZHMgb24gRGF0YWJhc2VP aWRJbmRleElkLiAgV2UgYWxzbwogCSAqIG5lZWQgdG8gbmFpbCB1cCBzb21lIGluZGV4ZXMgb24g cGdfYXV0aGlkIGFuZCBwZ19hdXRoX21lbWJlcnMgZm9yIHVzZQotCSAqIGR1cmluZyBjbGllbnQg YXV0aGVudGljYXRpb24uICBTaGFyZWRTZWNMYWJlbE9iamVjdEluZGV4SWQgaXNuJ3QKLQkgKiBj cml0aWNhbCBmb3IgdGhlIGNvcmUgc3lzdGVtLCBidXQgYXV0aGVudGljYXRpb24gaG9va3MgbWln aHQgYmUKLQkgKiBpbnRlcmVzdGVkIGluIGl0LgorCSAqIGR1cmluZyBjbGllbnQgYXV0aGVudGlj YXRpb24uICBXZSBuZWVkIGluZGV4ZXMgb24gcGdfcGFyYW1ldGVyX2FjbCBmb3IKKwkgKiBBQ0wg Y2hlY2tzIG9uIHNldHRpbmdzIHNwZWNpZmllZCBpbiB0aGUgc3RhcnR1cCBwYWNrZXQgZm9yIGEg cGh5c2ljYWwKKwkgKiByZXBsaWNhdGlvbiBjb25uZWN0aW9uLiAgU2hhcmVkU2VjTGFiZWxPYmpl Y3RJbmRleElkIGlzbid0IGNyaXRpY2FsIGZvcgorCSAqIHRoZSBjb3JlIHN5c3RlbSwgYnV0IGF1 dGhlbnRpY2F0aW9uIGhvb2tzIG1pZ2h0IGJlIGludGVyZXN0ZWQgaW4gaXQuCiAJICovCiAJaWYg KCFjcml0aWNhbFNoYXJlZFJlbGNhY2hlc0J1aWx0KQogCXsKQEAgLTQyMTQsOCArNDIxOSwxMiBA QCBSZWxhdGlvbkNhY2hlSW5pdGlhbGl6ZVBoYXNlMyh2b2lkKQogCQkJCQkJCUF1dGhNZW1SZWxh dGlvbklkKTsKIAkJbG9hZF9jcml0aWNhbF9pbmRleChTaGFyZWRTZWNMYWJlbE9iamVjdEluZGV4 SWQsCiAJCQkJCQkJU2hhcmVkU2VjTGFiZWxSZWxhdGlvbklkKTsKKwkJbG9hZF9jcml0aWNhbF9p bmRleChQYXJhbWV0ZXJBY2xQYXJuYW1lSW5kZXhJZCwKKwkJCQkJCQlQYXJhbWV0ZXJBY2xSZWxh dGlvbklkKTsKKwkJbG9hZF9jcml0aWNhbF9pbmRleChQYXJhbWV0ZXJBY2xPaWRJbmRleElkLAor CQkJCQkJCVBhcmFtZXRlckFjbFJlbGF0aW9uSWQpOwogCi0jZGVmaW5lIE5VTV9DUklUSUNBTF9T SEFSRURfSU5ERVhFUyA2CS8qIGZpeCBpZiB5b3UgY2hhbmdlIGxpc3QgYWJvdmUgKi8KKyNkZWZp bmUgTlVNX0NSSVRJQ0FMX1NIQVJFRF9JTkRFWEVTIDgJLyogZml4IGlmIHlvdSBjaGFuZ2UgbGlz dCBhYm92ZSAqLwogCiAJCWNyaXRpY2FsU2hhcmVkUmVsY2FjaGVzQnVpbHQgPSB0cnVlOwogCX0K ZGlmZiAtLWdpdCBhL3NyYy9pbmNsdWRlL2NhdGFsb2cvcGdfcGFyYW1ldGVyX2FjbC5oIGIvc3Jj L2luY2x1ZGUvY2F0YWxvZy9wZ19wYXJhbWV0ZXJfYWNsLmgKaW5kZXggYTI2YjA1YTliZjIuLjkw MmUyNjY2MDY5IDEwMDY0NAotLS0gYS9zcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3BhcmFtZXRlcl9h Y2wuaAorKysgYi9zcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3BhcmFtZXRlcl9hY2wuaApAQCAtMjks NyArMjksNyBAQAogICovCiBCRUdJTl9DQVRBTE9HX1NUUlVDVAogCi1DQVRBTE9HKHBnX3BhcmFt ZXRlcl9hY2wsNjI0MyxQYXJhbWV0ZXJBY2xSZWxhdGlvbklkKSBCS0lfU0hBUkVEX1JFTEFUSU9O CitDQVRBTE9HKHBnX3BhcmFtZXRlcl9hY2wsNjI0MyxQYXJhbWV0ZXJBY2xSZWxhdGlvbklkKSBC S0lfU0hBUkVEX1JFTEFUSU9OIEJLSV9ST1dUWVBFX09JRCgyMTczLFBhcmFtZXRlckFjbFJlbGF0 aW9uX1Jvd3R5cGVfSWQpIEJLSV9TQ0hFTUFfTUFDUk8KIHsKIAlPaWQJCQlvaWQ7CQkJLyogb2lk ICovCiAKLS0gCjIuNDMuMAoK --=-5aZHONW8ukzB/0hPIJ9F--