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 1sswQy-00C7uY-H0 for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Sep 2024 03:41:53 +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 1sswQx-001kIv-Nv for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Sep 2024 03:41:51 +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.94.2) (envelope-from ) id 1sswQw-001kIn-Fu for pgsql-bugs@lists.postgresql.org; Tue, 24 Sep 2024 03:41:51 +0000 Received: from fout-a6-smtp.messagingengine.com ([103.168.172.149]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sswQr-000lhL-FX for pgsql-bugs@lists.postgresql.org; Tue, 24 Sep 2024 03:41:49 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id 9524D138045A; Mon, 23 Sep 2024 23:41:44 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Mon, 23 Sep 2024 23:41:44 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1727149304; x=1727235704; bh=ebHxOWcFK8 0T89hYMV09HHqohF4oN1nqT/AzkSta3ag=; b=m4DlnoG0cH1H2tZe2z6/sOGqln vDwFIixuA9jH9KeckcgG1qAVtI8wt4xAS4dlqOvTvLYztLTbJ0vjQN2zEwIKleJR 8iHH2kOcYz9ObMDhy+EJyaWBFscL6r5JdpzOQIqrZs4BRX7VCYmbt0S1ggy2arM1 aFAPBmgxPm9dJceIXDTvz1IdXaN0yypjtMW18SH8yeUDGBAuhTQ0N3oSfyhajuMu DGvoh4haGipGr161nj9FB91uNOz6p3nMH9MAXPhvJOWk0Qsk8TCLsWQfgzXNQqs2 vWEZN7dCHjl2nwBMHirtZVA0TFogwQlA5h1ZwxnM3hhwnW+37WuauW3xNsRg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1727149304; x=1727235704; bh=ebHxOWcFK80T89hYMV09HHqohF4o N1nqT/AzkSta3ag=; b=m23e0TLOd/eMJggfW9w4DWafal3PLnkDOuKInG3JimQV KsVfbAsvyjIIu2MetEVplFkzi/PXsHOPo7hAjzmC7cj/FCF3k7ryZaCNZ2AJp91S nQu5UO1PvJ/s7YiQMlcUFsdh3iWNuJP7PNpueoW2RG4pA1lEeo+AGpohQguAjq1p pAICtjblw7bViEVb+5qzGLxbFgNnr3YGadFWlPefsMoRJBqGwfi7TXD5Aw6L2/6W sDKaJnKtMAsD5xbCORsT5UaaqSXTX77yEkWdyX5lnBQ3RXtMsYne//turNwsY4K/ 6FwULI4AW1nh4CKA9bh7+M5aq2ph963bFAN2fGm/4w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvddtuddggeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdlje dtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttdejnecuhfhrohhmpefo ihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihii eqnecuggftrfgrthhtvghrnhepveetjefgjeevgedukeehieeuieeuieevueeiudegheev uefggfduueelgeelieetnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidpnhgspghrtghpthht ohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepnhdrkhgrlhhinhhinhesph hoshhtghhrvghsphhrohdrrhhupdhrtghpthhtohepphhgshhqlhdqsghughhssehlihhs thhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 23 Sep 2024 23:41:42 -0400 (EDT) Date: Tue, 24 Sep 2024 12:41:23 +0900 From: Michael Paquier To: =?utf-8?B?0J3QuNC60LjRgtCwINCa0LDQu9C40L3QuNC9?= Cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18609: Repeated installcheck failure in test_pg_dump due to existing role Message-ID: References: <18609-4f426b9a2809baa8@postgresql.org> <61043C0D-A79D-457A-AC2A-4719D036FBCD@yesql.se> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="oLKob1v4a17nn6HW" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --oLKob1v4a17nn6HW Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Sep 23, 2024 at 03:21:13PM +0700, =D0=9D=D0=B8=D0=BA=D0=B8=D1=82=D0= =B0 =D0=9A=D0=B0=D0=BB=D0=B8=D0=BD=D0=B8=D0=BD wrote: > Yes, it will be enough to add DROP OWNED BY.=20 > Perhaps with these changes, we can allow meson builds to run the > test_pg_dump test in installcheck mode on the REL_16_STABLE branch? Yes, like b0c5b215dace, we should. REL_17_STABLE is frozen this week for the new major release, but the other branches are not, so I have applied a cherry-pick of 936e3fa3787a to 12~16, and b0c5b215dace to 16. -- Michael --oLKob1v4a17nn6HW Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmbyNOMACgkQnvQgOdby QH2TaBAApUv27ADN/FXXJbfd3tjBIf2rZhlJrxx5X8qyfFjbRPZgL+hNwheE+pJc Crer8qemVJggLee7M4sBc2aH98Z0ttswBKOdr2OZcsbeElVZT3ai/xfVVgOfB3fP FHdFhK63wZey9QcGKpbIzO8Pv1BWt/s645uolKC2JhsC+DspwpOHVk5ea0EP1f/k UYD8caekpSzUqA6Nu4jRZlYKShpV9WnYXzc4wCWIq2fkf3+GYTWRmqvvGVgtFSls 5s8PefJahCQLFiNbf82EKrF8XkALm67L62qZWJLCfkZmZmLAgnEvqL3RwY+yyhGT 6yrn9kE/FpruARt/unj8sZa+VRov6r0NeCutsa+P5YQJFYrR99uNbA7eCnHs5llP XIAGqlAAhG2YmV4iDRfnfVRjXt6ucssoA/Iuq3dI1SR6jDB85aqpFWLcAWer9PcA Zf6xvIEnDDuv5CeQc7NUoy3Nv2rVmZKV5U11iqPHqHo4AlDtjpC/nCXBHoHBq+aV SXPU8y9nXNYxqbEiuBi+HByubnLNTRt0QyijgnP/uQjqZLdS6fLykCdAQHMaM0Mf G+Em8ngj4SFczLJEhG0rhvzT5uJlI/42OiNucwBocOwwcssc0lr4arFesycMCM26 BtB1eI5Ondaj3XxGpj+x+ngNA29olWkm444dJOlDw8yw5/qiB94= =2moQ -----END PGP SIGNATURE----- --oLKob1v4a17nn6HW--