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.94.2) (envelope-from ) id 1v0l7c-000EP9-0a for pgsql-www@arkaria.postgresql.org; Mon, 22 Sep 2025 18:18:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v0l7a-001bPP-MZ for pgsql-www@arkaria.postgresql.org; Mon, 22 Sep 2025 18:18:42 +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.94.2) (envelope-from ) id 1v0l1m-001ZFC-AZ for pgsql-www@lists.postgresql.org; Mon, 22 Sep 2025 18:12:42 +0000 Received: from smtp.cmatte.me ([54.37.205.152]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1v0l1j-001o2R-0M for pgsql-www@lists.postgresql.org; Mon, 22 Sep 2025 18:12:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=cmatte.me; s=myselector; t=1758564756; bh=yye5nUHBVrZDFo7aDHOSehVitBI+we7GUcL/GD9RHBI=; h=Date:To:From:Subject; b=By7OZ/xwAcDkQskhrvbT9MMXqpQM6JWEDFMkYO7hJ6URcxZIEJeSwezoIIPvuP7Mi TL+x/n4zb87C8Ar7GTNVKX9C4J4vtXGu/jOww7v2DvICjIyoMX+ktB3rgLsPhmnBHE IHLIa8pjQerARWCUsCAhEb0Ek9k7xqDvwNLTUjhfL8MjOFXY1AXWWDlBxUNS4eZuqi wpZ/GMgqEjET/nAEafQ/1GqadggEHv596UK/LvmkRFpM7Q35JgoiRxSudtWSr1qy8d aJy2vPsBRsMPuI/DH7HIrIDB2oHl2JCEYGvKMuQZHM/wgvlotRtoo7ReH6o7Oe6Qx+ 80BN4sP9xhMfg== Content-Type: multipart/mixed; boundary="------------Nct3BQm9esqz4EhU0pWUPycc" Message-ID: Date: Mon, 22 Sep 2025 20:12:35 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird To: PostgreSQL WWW Content-Language: en-US From: =?UTF-8?Q?C=C3=A9lestin_Matte?= Subject: pglister: pgarchives does not synchronize subscribers with email delivery disabled (proposed patch) Autocrypt: addr=contact@cmatte.me; keydata= xsFNBFQipO8BEADUvqE27QFRLuew+jnzTi1HupltXE+mcFXkCE3ksU4UIMpUDHud+Uje6HIA dHQuq4ovTZOrCsE6cmwZ7HXjG3/fwCTsmlL+/VlJM+ip3l4vAnlL9CaN1iPGERfiYEgyQ80J GeEaPAo4wPyuU/qE0OkBFsb25lyyfpycd6GZXCWEj2/lJtWqkRLx9S9kNms6PlbOGw2KBaeL H9a778Gk73ELkaV/rTmLISZSy5KFszHnesZeNCIwjJdiEPvrhR1W/Nux1h8ac1fUzmbGXoLv 2dCskYX8DHCTzEEDJs+jnS3JVcWA39DDWnpdkLCy8/dKFJtnC/bw8dAryAIyqtSERJhJ5k7r hTr2t7EMwkh+mjTgYc8ixxkUEeHmTz3QMgnWBaKB/GhNPrdlJEmPxdQnTftA5kek9hfcmdCR mitOZkrqq0N55i/PPb5YFCEMuEWDkJLdRN+oyQy4zz4qdqHxhLqNnVrKx56kuHCEvD8rMvJg qrBei2rmr/rXhLGqk5l8iTfNZNJBRDCTT2S+i07U8bHuRpFH7R80pdBgyvJM3JViA1EbxDxS aGrK9PcWnxSgdex+hYN3bNHsK3CLMcMf94fbZIpATDM28tgKFjiCWJq1z+EaWuV48LBRanxF wqMj/YhG7ydcWj+KD1tjhb3c5sPqxoFF7ZMA4SiquUO+1Qis9wARAQABzSNDw6lsZXN0aW4g TWF0dGUgPGNvbnRhY3RAY21hdHRlLm1lPsLBjgQTAQgAOBYhBGQwFWxY/5W4fqkPMKGmKP7L aovWBQJfXjSKAhsDBQsJCAcCBhUKCQgLAgQWAgMBAh4BAheAAAoJEKGmKP7LaovWfM8QAIUs CDNGHU7h21/2v2JJCWuBKNdildxhZq1V1r/orOIqVSqkpR2FUrfrUgjyIhHAVwmS7wZJkWFA zQB5bJqkwMsktZT84mZOJHGJm7xLUxvLg+Rmii8uarsw/rUjZodkHc+wXO69AZkupZlGMoFe wqbjLmkAW1YhxVoHwaG/SLqRrBNHInruHRhWkRzuiw9H689t2h9TmtQDmchiiI5zi8OlfYb4 BfCaE0MzNITXqD3u63BRs/SMhEJLvpLw7DiN5fqv3uEXy/Bm9qPpZIIftKTty80UF774ePWA rz9fDBzN1pS4CHCKYdps3gTi/5jB0f8LKhyDdSU7dhztepUB+pbuLu2dffdJKo4gWT3ArjiU LtWe7zX+XzCV/rthLFn97UhFa+cBok7qmJhE+XUT0TWCqZVJxogqyzMKsicrO25SQmcUs7pm 17DVMNeZzLSPxcqfISq7PG+CNxPQ0BFwlSc+MD250m6IStgcStXPwq0oIysC9yiBBYfvgZv4 bCIVSkqpzJGLds2cEXIAgy3xfrzBxJtC1MYSwlQLhRd17mKQ/aqSBA7zERVzoIhxiMOB4KYO qG8CJu3IQg0joEQlbye8ABbseoEvBlqgtWN6yzQjvsSMwiq+2oJWy4FuhNiBE2IQCil7eND1 ooLs/X2BVMsaZfED1yuc/lPXOj9lVigWzsFNBFQipO8BEADeHZ3bYugmz1RuhSCgEggFLsPk 1Xax9Ru3ePx+i2BopZPZjhQknHyEF3J+R1Rrr77JoaT3YQE3y+zgEt3XNGP+LNcCLexvJv6X Nezt78PABfm9m94ZCft9hzXhJPvZ8sgT8HaTVX6zKiLhuGi54JaemtITBg1aFuA85AwXI69S GCUR6osaGKOchBq1jPCaiWLpCFGKnjDHkV9JhLRyCMP+4Vk+cvEq+rsKff0dt7viTlq0lELZ gPVoXKyMbM+bWavQf4kKMmk3dvtWUOti2nAR9zvsXq3EoYVWidLro/hefb6fcDiYFSqfcZd7 YOQkAKdLo1L//BZSPqfGfW/FtMuuHK9hVIwqSxnT2N8FPimg3/IZrCGV4zAQXaKxcwO7a2Y1 vzDBOyPol72JuLbGzoTuCiFmcZKdbHt2CeVTIoBC+YSwTxnbALdPYWml6hvNjdi34iyPfAVh Yymn0iOyT0gyMiTIWzWKL84DzOxeWlPUmyiTf0qRlAYn3FpGbv36Yczq3tva1HYua2rKkio6 yDw+6QgrzehU/YFBAfAEI5/wuhUlmnpDZm3+aGQebX7YLZqMYp6gRZxzTB3YWIIsdJg+mVP5 rkZ/YLGWT3CC0YFrtfhhmrVu1cUl5vAL1Q4dpMb2y4UNhQmQgLjz+absxF1mCN16X8inScs/ qp+SZVxabQARAQABwsFfBBgBAgAJBQJUIqTvAhsMAAoJEKGmKP7LaovWrJkP/2pZrES5hbZI z2FRoeecRF+aWckBPoSZFTa5FebmkaDeRtLoZyOIWcHIsrxT2zIDuPVc0gH9H9zjjZHmjW0B 3SQRir2kuTzQ2RzyhQs4EeAyzwUlJamBVgntDF+CD2B4pfCOOWOF0zZIIHbXizWgiaXcyIT3 Wx7slI8B8yeiZN1dFAy6mEUXgRPDsN3XfgCaGkBxePo94JdaZAmHiI+YkLLora34Zt7vHJz1 /qiTjMgR5kYNbIpy0qAJC/Tu9UHmoWHFuTrQAZYeMpIFMosHwSEDaeuJYikmo8w2DUN0W4GI G5bAujb3CFPrpcLzN21+ptwOHhtEbsppqs4HSduti+J85BEH+KOeOf3GyxpJ1bLz55ra9Jqa MJcNvTBaXWK0NrrWJSyKI+IHZQ/s+sjvmsj6gdEMHLwArchiRvLQiQjecP7zAp/t54dqjW8b +voTw+EnUpsy0eTHBX+JJVGgRNHz69yxg/hGHkceVzsRFRaA3gKDKT9Zl3hHA1oTuPAPTSGm TGBsc2hddW9iXNEpakhCcHMQpz7jomxGJ73X9ivE6SbXbc+hYZqw4LOKevmve5OUeu9Qujsi wfD7VG7b1yd7wEf34UrG6ngHZJgnpGNkXB37x1qfYNbt2qMDZ3yXb8KBCAvseqpyj75SOM48 lPe3upjh6RtDfF/pt1INmHsD 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. --------------Nct3BQm9esqz4EhU0pWUPycc Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable The pglister_sync script is supposed to synchronize subscribers from pgli= ster to pgarchives, so they can access archives. From what I understand of its semantics, the "nomail" field (labeled "Di= sable mail delivery") is used to remain subscribed, to be able to access = archives, without receiving emails. However, due to the way the API works, this is not the case. pglister_syn= c.py makes a call to the API, which get subscribers from the mailinglist_= subscribers SQL view. This view is built in the 0027_merge_migrations.py = migrations and excludes users with nomail. I propose a patch with a migration to change this SQL view to include nom= ail users (copying previous definition, without "AND NOT nomail"). Note that this changes results of the API, which might have consequences = if other scripts use it (I haven't found any with some grepping). --=20 C=C3=A9lestin Matte --------------Nct3BQm9esqz4EhU0pWUPycc Content-Type: text/x-patch; charset=UTF-8; name="0001-Include-nomail-users-in-API-call-results.patch" Content-Disposition: attachment; filename="0001-Include-nomail-users-in-API-call-results.patch" Content-Transfer-Encoding: base64 RnJvbSAzN2FkM2FiYzI4ODdmMjhmMTE4ZDFhZTQ3OGU3MDQ2OThiNzMxYzNiIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/Qz1DMz1BOWxlc3Rpbj0yME1hdHRl Pz0gPGRldkBjbWF0dGUubWU+CkRhdGU6IE1vbiwgMjIgU2VwIDIwMjUgMTk6NTc6MjEgKzAy MDAKU3ViamVjdDogW1BBVENIXSBJbmNsdWRlIG5vbWFpbCB1c2VycyBpbiBBUEkgY2FsbCBy ZXN1bHRzCgpPdGhlcndpc2UsIHBnYXJjaGl2ZXMncyBwZ2xpc3Rlcl9zeW5jIHdvbid0IGdp dmUgYWNjZXNzIHRvIHRoZXNlIHVzZXJzCi0tLQogLi4uNjBfZml4X21haWxpbmdsaXN0X3N1 YnNjcmliZXJzX3NxbF92aWV3LnB5IHwgMjggKysrKysrKysrKysrKysrKysrKwogMSBmaWxl IGNoYW5nZWQsIDI4IGluc2VydGlvbnMoKykKIGNyZWF0ZSBtb2RlIDEwMDY0NCB3ZWIvcGds aXN0ZXIvbGlzdHMvbWlncmF0aW9ucy8wMDYwX2ZpeF9tYWlsaW5nbGlzdF9zdWJzY3JpYmVy c19zcWxfdmlldy5weQoKZGlmZiAtLWdpdCBhL3dlYi9wZ2xpc3Rlci9saXN0cy9taWdyYXRp b25zLzAwNjBfZml4X21haWxpbmdsaXN0X3N1YnNjcmliZXJzX3NxbF92aWV3LnB5IGIvd2Vi L3BnbGlzdGVyL2xpc3RzL21pZ3JhdGlvbnMvMDA2MF9maXhfbWFpbGluZ2xpc3Rfc3Vic2Ny aWJlcnNfc3FsX3ZpZXcucHkKbmV3IGZpbGUgbW9kZSAxMDA2NDQKaW5kZXggMDAwMDAwMC4u NWY0OWU0OAotLS0gL2Rldi9udWxsCisrKyBiL3dlYi9wZ2xpc3Rlci9saXN0cy9taWdyYXRp b25zLzAwNjBfZml4X21haWxpbmdsaXN0X3N1YnNjcmliZXJzX3NxbF92aWV3LnB5CkBAIC0w LDAgKzEsMjggQEAKKyMgLSotIGNvZGluZzogdXRmLTggLSotCitmcm9tIF9fZnV0dXJlX18g aW1wb3J0IHVuaWNvZGVfbGl0ZXJhbHMKKworZnJvbSBkamFuZ28uZGIgaW1wb3J0IG1pZ3Jh dGlvbnMsIG1vZGVscworCisKK2NsYXNzIE1pZ3JhdGlvbihtaWdyYXRpb25zLk1pZ3JhdGlv bik6CisKKyAgICBkZXBlbmRlbmNpZXMgPSBbCisgICAgICAgICgnbGlzdHMnLCAnMDA1OV9y ZmM4MDU4JyksCisgICAgXQorCisgICAgb3BlcmF0aW9ucyA9IFsKKyAgICAgICAgbWlncmF0 aW9ucy5SdW5TUUwoIiIiCitDUkVBVEUgT1IgUkVQTEFDRSBWSUVXIG1haWxpbmdsaXN0X3N1 YnNjcmliZXJzIEFTCisgICBTRUxFQ1QgbGlzdF9pZCBBUyBsaXN0aWQsCisgICAgICAgICBs cy5zdWJzY3JpYmVyX2lkIEFTIHN1YnNjcmliZXJhZGRyZXNzX2lkLAorICAgICAgZW1haWws CisgICAgICBlbGltaW5hdGVjYywKKyAgICAgIHRva2VuLAorICAgICAgcy51c2VyX2lkIEFT IHVzZXJpZCwKKyAgICAgIChTRUxFQ1QgYXJyYXlfYWdnKGxpc3R0YWdfaWQpIEZST00gbGlz dHNfbGlzdHN1YnNjcmlwdGlvbl90YWdzIGxzdCBXSEVSRSBsc3QubGlzdHN1YnNjcmlwdGlv bl9pZD1scy5pZCkgQVMgdGFncworICAgRlJPTSBsaXN0c19saXN0c3Vic2NyaXB0aW9uIGxz CisgICBJTk5FUiBKT0lOIGxpc3RzX3N1YnNjcmliZXJhZGRyZXNzIHNhIE9OIHNhLmlkPWxz LnN1YnNjcmliZXJfaWQKKyAgIExFRlQgSk9JTiBsaXN0c19zdWJzY3JpYmVyIHMgT04gcy51 c2VyX2lkPXNhLnN1YnNjcmliZXJfaWQKKyAgIFdIRVJFIGNvbmZpcm1lZCBBTkQgc3Vic2Ny aXB0aW9uX2NvbmZpcm1lZAorIiIiKSwKKyAgICBdCi0tIAoyLjUxLjAKCg== --------------Nct3BQm9esqz4EhU0pWUPycc--