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 1ts6ky-00FJFj-G5 for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Mar 2025 21:03:20 +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 1ts6kw-006wWS-GC for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Mar 2025 21:03: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.94.2) (envelope-from ) id 1ts6kw-006wWJ-41 for pgsql-hackers@lists.postgresql.org; Tue, 11 Mar 2025 21:03:18 +0000 Received: from fhigh-a1-smtp.messagingengine.com ([103.168.172.152]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ts6kr-002J05-2Y for pgsql-hackers@lists.postgresql.org; Tue, 11 Mar 2025 21:03:17 +0000 Received: from phl-compute-13.internal (phl-compute-13.phl.internal [10.202.2.53]) by mailfhigh.phl.internal (Postfix) with ESMTP id EBABF1140172; Tue, 11 Mar 2025 17:03:12 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-13.internal (MEProxy); Tue, 11 Mar 2025 17:03:12 -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=fm1; t=1741726992; x=1741813392; bh=/ Ua3LtRR4/ihSEDOwMTSIfbP3cM1nv0Uzp2pDtyK7mI=; b=XpchzlYCREfnfoXhT cG+NRE3PKLNCT6m4XzxjPeoqWoeLR/aMV5G26Czc91Wot/SC5hlcxQZxY2YSvP4R VuOoTEYDcqLnKG0S9rYrfw6Q+TyJeSOY2oswpRgIjYZJuxwCeM8n1+i0+9YYMuZl hjOuQqhHOeNEyT/JH3LxSoGNMqOaeljVeh1nKsU3tHxr9+LGe/F28H2VRQ4x47zP tLdV/t9qfuvbByCbvSImvqJ+I+D8l/zhyfvNet0zzgm//TRG2CJqufWxEs1O23Np QcHulhXCKh13fIyGLgZCbsrA7HqI1+9oVgYWqcQrVhe/AOdW1D05Pn95H7nbo0Kb d3pcw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduvdefvdeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesthekredttddt jeenucfhrhhomheplmhlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlh hvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepvdehueffhefgueekueef heehgffhuefgfedukeejveduffegffekgeffffevgeehnecuffhomhgrihhnpegvnhhtvg hrphhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhep mhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgpdhnsg gprhgtphhtthhopeeipdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrnhgurhgv fiesughunhhslhgrnhgvrdhnvghtpdhrtghpthhtohepjhhirghnrdhunhhivhgvrhhsrg hlihhthiesghhmrghilhdrtghomhdprhgtphhtthhopehmrghhiheirhhunhesghhmrghi lhdrtghomhdprhgtphhtthhopehsrhhinhgrthhhvddufeefsehgmhgrihhlrdgtohhmpd hrtghpthhtohepihhlmhgrrhhisehilhhmrghrihdrohhrghdprhgtphhtthhopehpghhs qhhlqdhhrggtkhgvrhhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 11 Mar 2025 17:03:12 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1741726989; bh=JNBkHESNneOwhMCXglQIRQm6wCE40JRu1db5YeU2gfM=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=JPUhhTaeS6aQsFQBJtAkSm+9YNE8Dv9G0j6oX3+rQz2i6aZpco7k5GgUQRmbThWmN /V9PXUlv+Z+/KFqjfkSHuJDQNGkL1G9jhfbYOEljTLyBNTcRFansdgymfUh9Eq1Umu iGDl2/yaFO2ZAVZp5T0yxgtGuODJFhLJOuj8NjEnRSsygh3vguJfTdCOTHHrXbH9bo 9Sn552VpGlorND/HOblQe4ol4R9t5rSOD7PNjl9y3bub3IPf29tMWjo38uzjSUUTU+ QA9VfL3aC+N0JpZ1MZ12S4JCi0rL5E0OKhYc/pKkeddRkrYJqnP7FzWuOCqIUQUPt+ uGWVkXyCDuiWw== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 80BA791; Tue, 11 Mar 2025 22:03:09 +0100 (CET) Date: Tue, 11 Mar 2025 22:03:09 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Andrew Dunstan Cc: Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= , Mahendra Singh Thalor , jian he , Srinath Reddy , pgsql-hackers@lists.postgresql.org Subject: Re: Non-text mode for pg_dumpall Message-ID: <202503112103.fltgs54vpq6f@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 On 2025-Mar-11, Andrew Dunstan wrote: > I'm not sure everyone thinks that was a good idea for backup manifests (in > fact I know some don't), and it seems somewhat like overkill for a simple > map of oids to database names. If such a simple system can be made to work for all possible valid database names, then I agree with you. But if it forces us to restrict database names to not contain newlines or other funny chars that are so far unrestricted, then I would take the other position. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "La victoria es para quien se atreve a estar solo"