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 1ts8Dz-00Fk6s-8U for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Mar 2025 22:37:23 +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 1ts8Dx-008Un9-PC for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Mar 2025 22:37:21 +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 1ts8Dx-008Ukv-9v for pgsql-hackers@lists.postgresql.org; Tue, 11 Mar 2025 22:37:21 +0000 Received: from mail-qv1-xf2a.google.com ([2607:f8b0:4864:20::f2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ts8Dt-002JuP-1x for pgsql-hackers@lists.postgresql.org; Tue, 11 Mar 2025 22:37:20 +0000 Received: by mail-qv1-xf2a.google.com with SMTP id 6a1803df08f44-6e8f4c50a8fso46580886d6.1 for ; Tue, 11 Mar 2025 15:37:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1741732637; x=1742337437; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=zMHXICRPVxp6gr2885WhzRBNBF1eLAHTn92GkaVPioM=; b=fT9mzOQY5+TYkglLmElxuBHqKkgDmgR/7syE5LwLZKNCq7a3XHbZ1HMyIyQKDBDMJM OA9kJov9ogbZIEUVz46nPS5Ov/xY2PlYlYmwV6ZWhKbEfzbxpYx61YYx2ZrDd8VhEKn+ bxs/mZdeWm+WK7TxFDa6R/B7x6KsHlWL4cv7uVIohFOhIOOAVN+0sMbD+O8wzgAf9iJz 45Sqm+RY9wjj5ByYBrAcFuNJA8v1WyJvpSLeEynNLYRLPcg4omHd7lmoD5NzEh8yLVOW x8R+ROpQhgXLwM1Ae2Vt6ELd7t4W4OdSPe6kKJkNtkzUqLGE9xdgCApNEA9+2JXhL4iq TvsQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741732637; x=1742337437; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=zMHXICRPVxp6gr2885WhzRBNBF1eLAHTn92GkaVPioM=; b=GGFb+Y+6iFfyGDGPS3rcJm7963zQd5jIX+72UrTgIPwtpjG7dQUtXE7vOOze8RPXgc czI9JHeg/qIAxLDaJ/SOxNrWpyKefFk4FBtbWV54wZzf6tMi0fRefjxdibK05jaTFhCd AC9dHVVKnIDHNDtI212dXZ8mJnWeqEGr4WrRX2ADE8iZXafvwizIJI7iJjrQX9TFmQS7 rkXoiuLSlYoELfSi4scxBKYiw1C4NCpaUuG7HTfL+AkEcKULIdIsEoXu+i8GGFpkyMI9 phyFE5jJs/r0hDonvHoxzjoz88kVqiSo0fS7eBmP2GlT2zXWmMXcUnznr+bAKnglg6l8 Wszw== X-Forwarded-Encrypted: i=1; AJvYcCUavjFuPm9Veq4dNH2dj5PINEL6VubWA+QWSYc6eTkhAH4w2u+mGWmt9PLXc51J76/gc+l+rFYM2vFbgPGA@lists.postgresql.org X-Gm-Message-State: AOJu0YxOXNX4EkldE6f6/a3g1wbsxJgAhJefjNrmZkZKOEbY3fdi1sBJ PUHH+PQhsxU4H0Tf2wezmhEZWzgJEJUV5UZPayDem9JMCz+UbSPdwPt/ddPMfIg= X-Gm-Gg: ASbGncv47Zl1aESgHkuXxik/eKEjWx0FadwSaqjP0VAbEuOXV3lrJIsmIb4t5tq33pL IsHqP0aS4t8jma5CSvCxPqXJgLdQg3wPXOdU+s5bovU7Yl22iPIzNwNIusuySTJb6ggnwpflJft gWqL6Nxge8Z0w2nz55uwHdDgNadnrrHLYuDPqt3WAhMgWgCMenYm9qpiQsI77gV2sur4h8cF4G9 RE6HNuESZIAyZZNWITXXs6fxy4+M3TmRPSD2/GcptBsASoirSRNbKxcCz2gtDig01ODN2mXGUZW f5AFnc+SkuLVgMHAkqoCFiUbEtCpkKQ8wQ3n2YRN2zLJYJzbVfp0cyg= X-Google-Smtp-Source: AGHT+IGgvTxpPtEp030hxiT1tmgzJBLN+4ResmBVv3G3qqtHeufzlh3cag8cGVW8NdqUDd1P0TooCA== X-Received: by 2002:a05:6214:f27:b0:6e6:6c39:cb71 with SMTP id 6a1803df08f44-6e9006a7d70mr253563856d6.45.1741732636967; Tue, 11 Mar 2025 15:37:16 -0700 (PDT) Received: from ?IPV6:2605:a601:a681:6b00::1cb? ([2605:a601:a681:6b00::1cb]) by smtp.googlemail.com with ESMTPSA id 6a1803df08f44-6e8f715b781sm77206396d6.82.2025.03.11.15.37.15 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 11 Mar 2025 15:37:15 -0700 (PDT) Message-ID: Date: Tue, 11 Mar 2025 18:37:14 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Non-text mode for pg_dumpall To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: =?UTF-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= , Mahendra Singh Thalor , jian he , Srinath Reddy , pgsql-hackers@lists.postgresql.org References: <202503112103.fltgs54vpq6f@alvherre.pgsql> From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAmwQTAQgARQIbAwIX gAIZAQULCQgHAgMiAgEGFQoJCAsCBBYCAwECHgcWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUC ZFlxxwUJGVGAbgAKCRCZ+n/LWfw7gXikB/9ZdcUy6CTBFIIuL/bVsc1eLEW/gJBjJBF6HxNY xgEkAgXAp4Lg4A5U+QB9GouFr7+GYxF0BU4hzoGhNPUWltxnHdMWP8nC/38LAqgMi8L/bbsm HW5YPBdWYaAZAPJQVfOAgjTbRUb26KSprpyrrJKW0ZmrZfjhNPcQ72jpWzoPLQqx2X6B0fru 1jq+cBh8lb6r1mJTim1T3JIn+F/v5VpdQS+EL8xqsHkfzKjIPsW3CIXpkypSk6saA55Rkkbl 26AW8ftPVB0Q6Lnn6FLt9CP0MGNixBQ55yq8r1K+nCBvCCjvQjM8RDm0UUum0WNl+ifQgTLO E8TWEnwVtkBf+3QWzsBNBE7KWFkBCADRnOM0FCzsYW6jtncg+dWIagjUZpvaClmqn/sJluLa Q3v1VXMQJzYs3eC1gh386W+XBwLRpDj3jzH81lX+p73Re3d3oJW7X+ffsxuzu5ZVdMUkqBYo nkAbKxr6gyJ12F/+JkUVzLcoTN+d/7YsQvUVi7NaKH8mJgjz112O4fUe3p9wfAaFa0RXHc5S GPzRTYRRlv/XZBIho4J2tkZOnteZJZ+GbxQVlINt6fd8P6al3MWOvpP/ExJPguEfjOsO6Njy xjo3WfpD4lHMOR/Oc3/8mScEF84rF2jXbsFgelWnbPWAvXY+pD0dXOFRkagGmC/viwBDqq5b 5tk76kKmUbZxABEBAAHCwHwEGAEIACYCGwwWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUCZFlx 5wUJGVGAjgAKCRCZ+n/LWfw7gf+iB/4g8CPY5jihf5r/8EsoIGe2H+dpVmpPF8YGBzTIvCz/ fQoOq8AX/pE76QEuFnFZWfjw+wgBXgCVmkox2Eflkk6z4ND3pcwGZ6CfCxTQCDk/dij+2DQ4 6bmDCy/sBgcbz9mTpoLC11HLoPae6YN9nBNQRZDcEFEu54OaVOqlIdbA6m+POIBCXZdHOFc0 WoDTgxHRzC1jgQNidyd6tKqcsVJs0dzF0oKTmFFmUAqTdJO12LBuNA1rlqrR3EtpYk8B/wtS 5dIMD7Q8hwQpL+4C6GNpb6ZKnPkLi47pDOLhz2qBrqN+rqUEsT3YnExYpzj5yOBi+FlmV1Hw 49QYe1sn2ZPs In-Reply-To: <202503112103.fltgs54vpq6f@alvherre.pgsql> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-03-11 Tu 5:03 PM, Álvaro Herrera wrote: > 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. > Well, JSON is supposed to be UTF8. What should we do about database names that are not UTF8? It's kinda tempting to say we should have the file consist of lines like:     oid base64_encoded_name escaped_human_readable name cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com