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 1wOvXD-000HwQ-1a for pgsql-hackers@arkaria.postgresql.org; Mon, 18 May 2026 10:49:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wOvXB-001mbI-1E for pgsql-hackers@arkaria.postgresql.org; Mon, 18 May 2026 10:49:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wOvXB-001mbA-0D for pgsql-hackers@lists.postgresql.org; Mon, 18 May 2026 10:49:18 +0000 Received: from mail-ot1-x334.google.com ([2607:f8b0:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wOvX9-00000000AlY-3GM5 for pgsql-hackers@lists.postgresql.org; Mon, 18 May 2026 10:49:17 +0000 Received: by mail-ot1-x334.google.com with SMTP id 46e09a7af769-7de7dc85b74so2226103a34.2 for ; Mon, 18 May 2026 03:49:15 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779101354; cv=none; d=google.com; s=arc-20240605; b=iURnFm5wBZmooPAAtzwHecXL7bm/9POJpMH2+oLh1mHQU45rcESugwDtryTygL6Zid KYx1MijtM3S2f1IpHikzh6LRKvNBwtSnW/gIqjQQD211REOckwBUzb7MEIx/9jAv/NUv BZ8jo90c6jjWCNve6LyobwP0hCGTWNUL9xRokK1Cz2RScopAdm1yUaW1q8yhS8jf9b/Z JDvl+r0PMo4xBRe0ji7ysQZLXCs1CABv7526eFLEasfnFQGUKfogiA5APDy529BTIlT9 ++oE6FqVfAj6HeLFynotnlTJpEg8+if8Q9tXOmQ1tZd8cQoXTb2mrZ5tVKClHfSB9YLW vzVQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=Anpzi0oMgI1sUqSfMPmzphSFqs5HNpuHqaX2tML7dF4=; fh=//yq4Tmr3BwYA+MQHPG8/ZAzA/+INE9wuIAfqtiKt/g=; b=GUPCkYN+5SSi8ZnS3Gir5bnvKvfAtMBgN2bwd6btaFCbCvmw7LGCJF/zFYR4FEn9i9 z/Ig2sBJ2vcQG58LIW3J1+LyRJPr2zyqgcjyGF3ioQwv8lEtdjcwbdNwVjpbdGQI5TfW C17tlfeNzbIHFsoDJ1CzMuCXf7YkMkPV6Cx99butsNonXYyaBt4zwDyor83WpwV9msP3 2OjXRr3fBAgkRu4dcKaEUWhmIBqAcNzBqNuqEMiammUTYGl+fHdYsRter5uQm00q3Ft3 pJ7Mac4js/1gVLT/R9cDnubJoOxjQOfkrFnSjwMmdb3QG0N50u4ZgRfoNNCvk/EcvAJS UD3Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779101354; x=1779706154; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Anpzi0oMgI1sUqSfMPmzphSFqs5HNpuHqaX2tML7dF4=; b=YyLDExKeb60dH+g29fcXy9yeqQgluzoNasGEKNoAwekeXtTBtLWThQ5troNNGUE+Fb JfRmNxKpygtxCpzTIi7WlGTGIuZvLCOV45mNNSPwPspbHCDQanbmxP70B0FphLCNQvqZ W3HPW8g6JkZV7h0u905Tq77kOy3XsStkvWN5iGVmYN8QAVkkWnBImjlx1Wg1CllOcrFg L1P0rZL9eV8zymAplUhCLe0VjEWDYJGwj/M5DN/UQoREJUny7Hf2crcjIjl5CqpTRACk NdvSmJN8Ja7/ej5cjA1wK9tqiI0neSRsf2xQNE+l/NQnpvOaN4bPOlb22jRHEwfJJK0M v8qg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779101354; x=1779706154; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Anpzi0oMgI1sUqSfMPmzphSFqs5HNpuHqaX2tML7dF4=; b=RoswB5Ctc6vfVSNvth5QnEWwlkPyVOx9IJNCzr1G5ARnlf750nrx6q/FxAh8yhT5+J +Y4zr/sQJq0Y/ZeEwMQugu5hc82hhBmF7Ss4pBcQ3EIcfUfqa3M3SEP0Ului2vWuEmO3 euu6yXJ/S47mMM8VvvkSwMFzMnOH13NMxLTSu0uNa+yMJHIykw6aicxFjbSix7XHssk+ QCPdrF5+dKSUCQZlpsInv33S55MWcUOIBTcZqZq29wzhw7RrtvCH/9KSb48NQG+JZOhk R8wKZ2mjlbjBybO8nuVwUJprUfkM4Xdpf9jmnlTj3z7xUskzjnqNyO6b27yF1GYDZlH5 quww== X-Gm-Message-State: AOJu0YzDkOAYlgRwqSZumyyeKvVkDVCz+m1417/Fa6zANG4XF9BnbcKB VzhDggN+OpTTF6ClOgXz1FdBUTBg/uW5oqpQus+j6vx3vKyOUeF5+yRqYSEr7SM6RAgM7SSwWoZ PzxDAaayjjPHbv3JL+2qoAdX8Wzo32pSoWlb0xrI= X-Gm-Gg: Acq92OG/PCEETXaZkD4A15BS+u6S/9xAbA+5xzCxRbSdekvOzCWM2XuhiKX1rkzCje0 BhWaCQEuHFJWlmEfPtwy5oNTwPnjrMBm90hom0qUpjX4yasDVPpo5ykBetgx7zeB9B2D1qH2d0h OVHGfR1wCjCNY1FqkuO0n9XVYwU4n1bI90CyDPVmieBOQxoKMStDHWauIpNMyODLutCMfjUxNqq GfskMKXzu97Mf7O/mTKzgD14MF5nhKVmFMbRdtrfcvCmDLkcM4zFoQe+/iQsPsfRtiVkhdlaaoT 31AP2SWwFHWHuubcc9KvvnnXqJD3B0T8nCmpmdvIlg== X-Received: by 2002:a05:6820:f012:b0:696:97e7:7c63 with SMTP id 006d021491bc7-69c94291352mr8748200eaf.3.1779101353994; Mon, 18 May 2026 03:49:13 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Fujii Masao Date: Mon, 18 May 2026 19:48:57 +0900 X-Gm-Features: AVHnY4Iwyf6QPRfPcxqBW8sthSJPoagl11SahYc_9mrfx2XQJAB7fY7P0x_3c_s Message-ID: Subject: Re: pg_recvlogical: honor source cluster file permissions for output files To: Srinath Reddy Sadipiralla Cc: PostgreSQL Hackers Content-Type: multipart/mixed; boundary="0000000000003982750652155034" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003982750652155034 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, May 18, 2026 at 7:47=E2=80=AFPM Fujii Masao = wrote: > As far as I can tell, 010_basebackup.pl initializes the cluster without g= roup > access and checks the backup permissions, then enables group access using > chmod_recursive() and verifies that group permissions are also applied to > the backup. I updated the TAP test following this approach and attached > a revised patch. Sorry, I forgot to attach the patch. I've attached it in this email. Regards, --=20 Fujii Masao --0000000000003982750652155034 Content-Type: application/octet-stream; name="v2-0001-pg_recvlogical-Honor-source-cluster-file-permissi.patch" Content-Disposition: attachment; filename="v2-0001-pg_recvlogical-Honor-source-cluster-file-permissi.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mpb2yhd30 RnJvbSAxOWU0MmIxNDExOTI5N2RhZjhhNGJiZWRkNDU3ODczM2RkODU0MTJiIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5vcmc+CkRh dGU6IEZyaSwgMTUgTWF5IDIwMjYgMjI6NDc6MjggKzA5MDAKU3ViamVjdDogW1BBVENIIHYyXSBw Z19yZWN2bG9naWNhbDogSG9ub3Igc291cmNlIGNsdXN0ZXIgZmlsZSBwZXJtaXNzaW9ucyBmb3IK IG91dHB1dCBmaWxlcwoKQ29tbWl0IGMzN2IzZDA4Y2E2IGF0dGVtcHRlZCB0byBwcmVzZXJ2ZSBn cm91cCBwZXJtaXNzaW9ucyBvbiBwZ19yZWN2bG9naWNhbApvdXRwdXQgZmlsZXMgd2hlbiBncm91 cCBhY2Nlc3Mgd2FzIGVuYWJsZWQgb24gdGhlIHNvdXJjZSBjbHVzdGVyLiBIb3dldmVyLAp0aGUg b3V0cHV0IGZpbGVzIHdlcmUgc3RpbGwgY3JlYXRlZCB3aXRoIGEgZml4ZWQgU19JUlVTUiB8IFNf SVdVU1IgbW9kZSwKcHJldmVudGluZyBncm91cC1yZWFkIHBlcm1pc3Npb25zIGZyb20gYmVpbmcg YXBwbGllZC4KClRoaXMgY29tbWl0IGZpeGVzIHRoZSBpc3N1ZSBieSBjcmVhdGluZyBvdXRwdXQg ZmlsZXMgd2l0aCBwZ19maWxlX2NyZWF0ZV9tb2RlCmluc3RlYWQgb2YgYSBoYXJkLWNvZGVkIG1v ZGUuIFRoaXMgYWxsb3dzIHBnX3JlY3Zsb2dpY2FsIHRvIGNvcnJlY3RseSBwcmVzZXJ2ZQpncm91 cCBwZXJtaXNzaW9ucyBmcm9tIHRoZSBzb3VyY2UgY2x1c3Rlci4KCkJhY2twYXRjaCB0byBhbGwg c3VwcG9ydGVkIGJyYW5jaGVzLgotLS0KIGRvYy9zcmMvc2dtbC9yZWYvcGdfcmVjdmxvZ2ljYWwu c2dtbCAgICAgICAgICB8ICAyICstCiBzcmMvYmluL3BnX2Jhc2ViYWNrdXAvcGdfcmVjdmxvZ2lj YWwuYyAgICAgICAgfCAgMiArLQogc3JjL2Jpbi9wZ19iYXNlYmFja3VwL3QvMDMwX3BnX3JlY3Zs b2dpY2FsLnBsIHwgNDYgKysrKysrKysrKysrKysrKysrKwogMyBmaWxlcyBjaGFuZ2VkLCA0OCBp bnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9y ZWYvcGdfcmVjdmxvZ2ljYWwuc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvcGdfcmVjdmxvZ2ljYWwu c2dtbAppbmRleCA1MzgwZDc3NmJhZi4uNWY3NmU0MjRlMjYgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMv c2dtbC9yZWYvcGdfcmVjdmxvZ2ljYWwuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvcmVmL3BnX3Jl Y3Zsb2dpY2FsLnNnbWwKQEAgLTQ5NCw3ICs0OTQsNyBAQCBQb3N0Z3JlU1FMIGRvY3VtZW50YXRp b24KIAogICA8cGFyYT4KICAgIDxhcHBsaWNhdGlvbj5wZ19yZWN2bG9naWNhbDwvYXBwbGljYXRp b24+IHdpbGwgcHJlc2VydmUgZ3JvdXAgcGVybWlzc2lvbnMgb24KLSAgIHRoZSByZWNlaXZlZCBX QUwgZmlsZXMgaWYgZ3JvdXAgcGVybWlzc2lvbnMgYXJlIGVuYWJsZWQgb24gdGhlIHNvdXJjZQor ICAgdGhlIG91dHB1dCBmaWxlcyBpZiBncm91cCBwZXJtaXNzaW9ucyBhcmUgZW5hYmxlZCBvbiB0 aGUgc291cmNlCiAgICBjbHVzdGVyLgogICA8L3BhcmE+CiAKZGlmZiAtLWdpdCBhL3NyYy9iaW4v cGdfYmFzZWJhY2t1cC9wZ19yZWN2bG9naWNhbC5jIGIvc3JjL2Jpbi9wZ19iYXNlYmFja3VwL3Bn X3JlY3Zsb2dpY2FsLmMKaW5kZXggYmU3MTc4M2IzNzAuLjJmZGY2NGJjYWRiIDEwMDY0NAotLS0g YS9zcmMvYmluL3BnX2Jhc2ViYWNrdXAvcGdfcmVjdmxvZ2ljYWwuYworKysgYi9zcmMvYmluL3Bn X2Jhc2ViYWNrdXAvcGdfcmVjdmxvZ2ljYWwuYwpAQCAtMzQyLDcgKzM0Miw3IEBAIFN0cmVhbUxv Z2ljYWxMb2codm9pZCkKIAkJCQlvdXRmZCA9IGZpbGVubyhzdGRvdXQpOwogCQkJZWxzZQogCQkJ CW91dGZkID0gb3BlbihvdXRmaWxlLCBPX0NSRUFUIHwgT19BUFBFTkQgfCBPX1dST05MWSB8IFBH X0JJTkFSWSwKLQkJCQkJCQkgU19JUlVTUiB8IFNfSVdVU1IpOworCQkJCQkJCSBwZ19maWxlX2Ny ZWF0ZV9tb2RlKTsKIAkJCWlmIChvdXRmZCA9PSAtMSkKIAkJCXsKIAkJCQlwZ19sb2dfZXJyb3Io ImNvdWxkIG5vdCBvcGVuIGxvZyBmaWxlIFwiJXNcIjogJW0iLCBvdXRmaWxlKTsKZGlmZiAtLWdp dCBhL3NyYy9iaW4vcGdfYmFzZWJhY2t1cC90LzAzMF9wZ19yZWN2bG9naWNhbC5wbCBiL3NyYy9i aW4vcGdfYmFzZWJhY2t1cC90LzAzMF9wZ19yZWN2bG9naWNhbC5wbAppbmRleCAwNjNhZDk2Yjli ZS4uOTQ1YTI0MmJkYWQgMTAwNjQ0Ci0tLSBhL3NyYy9iaW4vcGdfYmFzZWJhY2t1cC90LzAzMF9w Z19yZWN2bG9naWNhbC5wbAorKysgYi9zcmMvYmluL3BnX2Jhc2ViYWNrdXAvdC8wMzBfcGdfcmVj dmxvZ2ljYWwucGwKQEAgLTIzNiw2ICsyMzYsNTIgQEAgbXkgJGNvdW50ID0gKCgpID0gJG91dGZp bGVkYXRhID1+IC9JTlNFUlQvZyk7CiBjbXBfb2soJGNvdW50LCAnPT0nLCAyLAogCSdwZ19yZWN2 bG9naWNhbCBoYXMgcmVjZWl2ZWQgYW5kIHdyaXR0ZW4gdHdvIElOU0VSVHMnKTsKIAorIyBDaGVj ayB0aGF0IHBnX3JlY3Zsb2dpY2FsIGRlcml2ZXMgb3V0cHV0IGZpbGUgcGVybWlzc2lvbnMgZnJv bSB0aGUgc291cmNlCisjIGNsdXN0ZXIuCitTS0lQOgoreworCXNraXAgInVuaXgtc3R5bGUgcGVy bWlzc2lvbnMgbm90IHN1cHBvcnRlZCBvbiBXaW5kb3dzIiwgMgorCSAgaWYgKCRDb25maWd7b3Nu YW1lfSBlcSAnTVNXaW4zMicgfHwgJENvbmZpZ3tvc25hbWV9IGVxICdjeWd3aW4nKTsKKworCSMg VGhlIGNsdXN0ZXIgd2FzIGluaXRpYWxpemVkIHdpdGhvdXQgZ3JvdXAgYWNjZXNzLCBzbyBwZ19y ZWN2bG9naWNhbAorCSMgc2hvdWxkIGNyZWF0ZSB0aGUgb3V0cHV0IGZpbGUgYXMgMDYwMCAoLXJ3 LS0tLS0tLSkuCisJbXkgJG1vZGUgPSBzcHJpbnRmKCclMDRvJywgKHN0YXQoJG91dGZpbGUpKVsy XSAmIDA3Nzc3KTsKKwlpcygkbW9kZSwgJzA2MDAnLAorCQkncGdfcmVjdmxvZ2ljYWwgb3V0cHV0 IGZpbGUgaGFzIG5vIGdyb3VwIHBlcm1pc3Npb25zICgwNjAwKScpOworCisJIyBFbmFibGUgZ3Jv dXAgYWNjZXNzIG9uIHRoZSBzb3VyY2UgY2x1c3RlciBhbmQgaXRzIGZpbGVzLCB0aGVuIHJlc3Rh cnQKKwkjIHNvIHBnX3JlY3Zsb2dpY2FsIG9ic2VydmVzIHRoZSB1cGRhdGVkIHNvdXJjZSBjbHVz dGVyIHBlcm1pc3Npb25zLgorCSRub2RlLT5zdG9wOworCWNobW9kX3JlY3Vyc2l2ZSgkbm9kZS0+ ZGF0YV9kaXIsIDA3NTAsIDA2NDApOworCSRub2RlLT5zdGFydDsKKworCSRvdXRmaWxlID0gJG5v ZGUtPmJhc2VkaXIgLiAnL2dyb3VwX2FjY2Vzcy5vdXQnOworCUBwZ19yZWN2bG9naWNhbF9jbWQg PSAoCisJCSdwZ19yZWN2bG9naWNhbCcsCisJCSctLXNsb3QnID0+ICdyZWNvbm5lY3RfdGVzdCcs CisJCSctLWRibmFtZScgPT4gJG5vZGUtPmNvbm5zdHIoJ3Bvc3RncmVzJyksCisJCSctLXN0YXJ0 JywKKwkJJy0tZmlsZScgPT4gJG91dGZpbGUsCisJCSctLWZzeW5jLWludGVydmFsJyA9PiAnMScp OworCisJJHJlY3YgPSBJUEM6OlJ1bjo6c3RhcnQoCisJCVtAcGdfcmVjdmxvZ2ljYWxfY21kXSwK KwkJJz4nID0+IFwkc3Rkb3V0LAorCQknMj4nID0+IFwkc3RkZXJyKTsKKworCSRub2RlLT5zYWZl X3BzcWwoJ3Bvc3RncmVzJywgJ0lOU0VSVCBJTlRPIHRlc3RfdGFibGUgVkFMVUVTICgzKScpOwor CXdhaXRfZm9yX2ZpbGUoJG91dGZpbGUsIHFyL0lOU0VSVC8pOworCisJJHJlY3YtPnNpZ25hbCgn VEVSTScpOworCSRyZWN2LT5maW5pc2goKTsKKworCSMgV2l0aCBncm91cCBhY2Nlc3MgZW5hYmxl ZCBvbiB0aGUgc291cmNlIGNsdXN0ZXIsIHBnX3JlY3Zsb2dpY2FsIHNob3VsZAorCSMgY3JlYXRl IHRoZSBvdXRwdXQgZmlsZSBhcyAwNjQwICgtcnctci0tLS0tKS4KKwkkbW9kZSA9IHNwcmludGYo JyUwNG8nLCAoc3RhdCgkb3V0ZmlsZSkpWzJdICYgMDc3NzcpOworCWlzKCRtb2RlLCAnMDY0MCcs CisJCSdwZ19yZWN2bG9naWNhbCBvdXRwdXQgZmlsZSByZXNwZWN0cyBncm91cCBwZXJtaXNzaW9u cyAoMDY0MCknKTsKK30KKwogJG5vZGUtPmNvbW1hbmRfb2soCiAJWwogCQkncGdfcmVjdmxvZ2lj YWwnLAotLSAKMi41My4wCgo= --0000000000003982750652155034--