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 1tzJdu-000hUz-21 for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Mar 2025 18:13:50 +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 1tzJdr-009xCK-91 for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Mar 2025 18:13:47 +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 1tzJdq-009xCC-Cr for pgsql-hackers@lists.postgresql.org; Mon, 31 Mar 2025 18:13:46 +0000 Received: from fout-a5-smtp.messagingengine.com ([103.168.172.148]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tzJdn-002H3I-0M for pgsql-hackers@lists.postgresql.org; Mon, 31 Mar 2025 18:13:45 +0000 Received: from phl-compute-09.internal (phl-compute-09.phl.internal [10.202.2.49]) by mailfout.phl.internal (Postfix) with ESMTP id 784EC1382D2E; Mon, 31 Mar 2025 14:12:39 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-09.internal (MEProxy); Mon, 31 Mar 2025 14:12:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1743444759; x=1743531159; bh=a XMfMEm1NNPaBxSQmsuHeONOP4GX7d77K9HpOpJrcu0=; b=B9QwxKtfbDY7WtpUi GYmux33i+xQT9eZG/tsgPCJGnyb7iukD8yasjljsFC5WiE7Y25oqdQ31cmkShlb1 HkIkygQGsiuThN63j+AJ9V8wNSLLSls4u4/B8/STrHoiQa44A7jGZrpj/mzbRX5b VEp6pU0syob6UuQ9aijNsrd7FxD4rPbC3K+fY3j3ZmXqU5HlqBD5zKEegLqlphOe hLAkNrzPAsqcNFcjugNk8vqzCCAaiBL17czgFTtC4evv+f9QQFq3hpWbVS4MdvBr HfpHQ4viMfVDLwnAJGM/sWGyWBzan9VH2+4DWNrto3AXlW7Z+uGq50G5LZX7mfnI 3y5iA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddukedtieduucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesthekredttddt jeenucfhrhhomheplmhlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlh hvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepvdehueffhefgueekueef heehgffhuefgfedukeejveduffegffekgeffffevgeehnecuffhomhgrihhnpegvnhhtvg hrphhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhep mhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgpdhnsg gprhgtphhtthhopeehpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrnhgurhgv fiesughunhhslhgrnhgvrdhnvghtpdhrtghpthhtohepjhhirghnrdhunhhivhgvrhhsrg hlihhthiesghhmrghilhdrtghomhdprhgtphhtthhopehmrghhiheirhhunhesghhmrghi lhdrtghomhdprhgtphhtthhopehsrhhinhgrthhhvddufeefsehgmhgrihhlrdgtohhmpd hrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrphhoshhtghhrvghs qhhlrdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 31 Mar 2025 14:12:38 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1743444756; bh=L04EbFWqLVHF9J6NMfRCxd7g2u8zQRo94BNcxtbQuf0=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=GuvTpleXnNaUmjNdz0xY/7aP1hR9uFo0gVNRgXrltMDuySraIotUdA34uCn55EiZA TC4w2d40cWuKYh7aNj9eLq0rYbTCX7uAIkl1FUBx8sgyxiNCgWVhNEzuX62pq+Kr6N Iju+I/A0fIWOVAV2khS6Bf0C1c6wvU4A6U5bM7FlJsJX71kYD7a5dipUdBNS9vL5pW W/BVeNG65V5Gj8unkefUeKc90Jfs7sjO0v+VCvgVRALVFVheJzg1jAGQUNTT5aEPV1 sBAsUzvzt3gaqMh5o2rfjIkSEmylnBnnL6nJrjTypZdXHsJu3uCjmB9JLNz2JbmRfe 0zubBTr53a6aw== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 7593889; Mon, 31 Mar 2025 20:12:36 +0200 (CEST) Date: Mon, 31 Mar 2025 20:12:36 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Andrew Dunstan Cc: Mahendra Singh Thalor , jian he , Srinath Reddy , pgsql-hackers@lists.postgresql.org Subject: Re: Non-text mode for pg_dumpall Message-ID: <202503311812.vxg5b7rzfgf6@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi FWIW I don't think the on_exit_nicely business is in final shape just yet. We're doing something super strange and novel about keeping track of an array index, so that we can modify it later. Or something like that, I think? That doesn't sound all that nice to me. Elsewhere it was suggested that we need some way to keep track of the list of things that need cleanup (a list of connections IIRC?) -- perhaps in a thread-local variable or a global or something -- and we install the cleanup function once, and that reads from the variable. The program can add things to the list, or remove them, at will; and we don't need to modify the cleanup function in any way. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/