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.96) (envelope-from ) id 1waD1Z-001bit-1b for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jun 2026 13:43:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1waD1Y-00BcGU-1G for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jun 2026 13:43:16 +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.96) (envelope-from ) id 1waD1Y-00BcGM-0E for pgsql-hackers@lists.postgresql.org; Thu, 18 Jun 2026 13:43:16 +0000 Received: from mail-qt1-x834.google.com ([2607:f8b0:4864:20::834]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1waD1V-000000016EC-3bfF for pgsql-hackers@lists.postgresql.org; Thu, 18 Jun 2026 13:43:15 +0000 Received: by mail-qt1-x834.google.com with SMTP id d75a77b69052e-51758478240so5263461cf.2 for ; Thu, 18 Jun 2026 06:43:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20251104.gappssmtp.com; s=20251104; t=1781790192; x=1782394992; darn=lists.postgresql.org; h=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=cdssvcTk3qA4xUv76AaBU+h6zdfy/qrRzd3vxbEkQ9Q=; b=lU5QGDnUNo28Yp/5qo8ux1qDj07O3YCv7h5uhkLlzQOz5/Fwc+P8B4BDoLXYRt50mx z1iqdP6DEQ9tX8ExTwQu3O+VSIzaAncIW8gSkHXD15a/kULmRuujhoDlH/ZffkEpWSY6 sgN4SD2P+21+R0mGXiUjpQctr8VqrMUhJ5d8dQR7+cfG2WzEwMdoSW+lZ9rVUUKaCu+q lBd4KLBjJWwxQkQtZ/xdPZLkZtsjxwwpeOCPZ32g2K9JhlCZFA4lh7diWUJIVj2pbU1Z jSlQyCxX8aRY4qXn85CDSA0t7H0DoYHTfk1jOJMSHqIbKOH6E5uNMuhohP8YpVbi5KFQ gB6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781790192; x=1782394992; h=in-reply-to:autocrypt:content-language:from:references:cc:to :subject:user-agent:mime-version:date:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=cdssvcTk3qA4xUv76AaBU+h6zdfy/qrRzd3vxbEkQ9Q=; b=c6/MChR0hqwF/Cqcth+ZKl7DRSJsRAmL/a8tTrc9fdNLlk05ehvSNLmVmaVk5KfEKS 04cHHADy5CudO83oHupwE+D3x4mOEuqfRPfyyPmE9mEIkWfvkccPd7hiVTIdyU+CWNJz AtNTB+50Do/0a9ioj7kFHh7t77XI37ahXK3FQz5gK8qAyS0EcNGYTPgg4hpoDJXUa4UK TULANBRxyFkISk2gqqTbOSs4JQbl/ql9welta7OddueMIXeMiS4zd8IElCW0ajjYlRf4 iJ3ZNsTXv37pmDgNs6hvb1IipZ4C4eNY+fRKjNE04+mOBwrB/iocRjvfIGyGIM9koNTE iLdw== X-Forwarded-Encrypted: i=1; AFNElJ9tbTBVUOR4SmwCjBo1DW60qRpAPPjYaA28s30UUG80LPm6bL7LEq83DyP+k3khloaLD6n1S0SjuaFfMa8s@lists.postgresql.org X-Gm-Message-State: AOJu0YwQhV0Oufcc89v1EXnuqc/MptvlRtnB2LzTJRWafinWNZzX2LJh b6dDtrwPq4vPIcAypazShN2bHpDU8d+rf405p2FbhrRp/aF/K8GaQ/YZdRRoXxlIc1Y= X-Gm-Gg: AfdE7clrilWlRqLn2P0w5RarNJDGdCccWV2PuARMDmen2WF78B5PaLboDkVAoVUMxGK xUxgmceWDsKQis+IpFLWiAcUxkn5zFdb8cIh3//srPXk4kJt6s1YMae7tAm5BYmQ5R/SU7OIzo9 gK57YgrTyjqTd0U84OQiOKpbK4f0tbVBes17TtHtOW92/zfuUorPr8NHvZpNO8rLILOfwzrz8ff GI1y/Ep95mV+cQVW4ADB+Yij11qRw3npHtO4cEtBG7Ep+LvRRALo3GDuEHfx5rT9FHmcHHaJffu vyIfeAXCamSwKIGvqzKi2XTcqFniMMj62iOT9yDd8uhu3RbY1KJWkX86Ub5eFL6kRSUGv6chAWZ Aqc41OnANbPDV6W74IhWThpNisDz651UI7kZAsSv0hKwpnkMVZarjiafoA7rKWK2mksJxDssEA/ d7ZrpdG9Bq3qUWYy1+C1VUwKTKYuHYl5s6CYOFJ8sqfUkhPx57HVKx8olENMGI X-Received: by 2002:a05:622a:a6ca:b0:516:ed02:c85a with SMTP id d75a77b69052e-519a8faddd7mr122349721cf.32.1781790191687; Thu, 18 Jun 2026 06:43:11 -0700 (PDT) Received: from ?IPV6:2605:a601:a6b0:500:ccb8:56eb:bfc6:86b5? ([2605:a601:a6b0:500:ccb8:56eb:bfc6:86b5]) by smtp.googlemail.com with ESMTPSA id d75a77b69052e-517fb61d948sm190695291cf.1.2026.06.18.06.43.10 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 18 Jun 2026 06:43:11 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------d7fRRZBKs3fs1TZHCm0bCtdS" Message-ID: <6e049195-7bf4-4f5f-932d-51f1251b2d92@dunslane.net> Date: Thu, 18 Jun 2026 09:43:09 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Non-text mode for pg_dumpall To: Noah Misch Cc: jian he , Mahendra Singh Thalor , tushar , Vaibhav Dalvi , pgsql-hackers@lists.postgresql.org References: <59d3616f-6d6d-40d5-87e2-e019e350b52d@dunslane.net> <7faf3a59-cfe1-45cb-a972-55e05560b414@dunslane.net> <2e7ada75-422c-4153-9437-ea0ce8d63521@dunslane.net> <84764ef6-2bcb-43f7-9037-d7b589857da9@dunslane.net> <20260607000218.96.noahmisch@microsoft.com> <20260617215952.1f.noahmisch@microsoft.com> 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 AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAlwQTAQgAQQIbAwIX gAIZAQULCQgHAwUVCgkICwUWAgMBAAIeBRYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNGd BQkdEO8nAAoJEJn6f8tZ/DuBq74H/jkTR4Zi3stbw+xC7v2u3QozssK7MYPL2AsVfh7OealS h182fiWXpfvmmAB7WUHbhk9GC2RAOnHI/2d2jgKaMLAHsGYOT0YopTVIwRY43fCw/mK67yxc wmDcX+zyKfLaivNbf5A7QPLNwda98bEAMSJ8Sn652Uc6cA8t3uKGsVzbRBQOoYzjgvBCfSrE 9ql3PDNg0l4BfAqabd2f70ZUm9VAMEPrgv/v2xI7M2XiL4g5BVmqLCOwxLM8RMCotCuoweUr VO43DeBCIDwLxotMJKvGWDjBzQYlU1NPUAtNcz/gN9ITUe1VUGjyvGj4u1lxBOcQQUw7l1+T 5moZ4iZxXzvOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oKWaqf+wmW4tpDe/VV cxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7llV0xSSoFiieQBsr GvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8BoVrRFcdzlIY/NFN hFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C4R+M6w7o2PLGOjdZ +kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaYL++LAEOqrlvm2Tvq QqZRtnEAEQEAAcLAfAQYAQgAJgIbDBYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNI2BQkd EODdAAoJEJn6f8tZ/DuBfw0IAKTsfD40teP/pp+bsLLMSxPXUYrrprTj7WFB5v61p6dkpSr/ qXmMlyahdxQFaPmfVgVirB1Vk/kHiWNnnGjfUV9nB2Zg9LI0Xb9/ts3LsUiRWXzG3tkMY6XL vsVOxW4XFRND9l2q+WW93aZ1DZl+fqWfYgMvsusFRhmGFOKTRfKPta2Pkv+AhA24N4+PrR5p bU4k2MO8PAGiK8eaYKGFG1bHKuAvoDoF7WXJ3FHxuWqLnKEt4dfOLm5pAe3zq1Lt6q8azT9i QWGpSAK5vQUWQHBHpiDjdPeqKZ6HiAXIIKfSmb+jrvXBqoP+D6/K7rUjG2aXiRtTIAXms9sm VRu7cmw= In-Reply-To: <20260617215952.1f.noahmisch@microsoft.com> 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. --------------d7fRRZBKs3fs1TZHCm0bCtdS Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 2026-06-17 We 5:59 PM, Noah Misch wrote: > On Mon, Jun 15, 2026 at 04:11:16PM -0400, Andrew Dunstan wrote: >> On 2026-06-06 Sa 8:02 PM, Noah Misch wrote: >>> On Thu, Feb 26, 2026 at 09:02:48AM -0500, Andrew Dunstan wrote: >>>> pushed with a slight tweak. >>> Having now reviewed commit 763aaa0, I don't think it's ready to remain part of >>> v19. While some points from my v18 review are now resolved, other points >>> still seem unresolved. I didn't find discussion of the unresolved points. I >>> also see new issues. >> OK, here's a reversion path. It's a bit messy, and I didn't touch the >> release notes, but apart from that I think it does the right thing. > I checked "git diff 763aaa06f03^ src/bin/pg_dump/{*.c,*.h,t}" and I agree this > reverts everything. Thanks for working through the revert. Thanks for checking. Pushed with the release notes update. cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------d7fRRZBKs3fs1TZHCm0bCtdS Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit


On 2026-06-17 We 5:59 PM, Noah Misch wrote:
On Mon, Jun 15, 2026 at 04:11:16PM -0400, Andrew Dunstan wrote:
On 2026-06-06 Sa 8:02 PM, Noah Misch wrote:
On Thu, Feb 26, 2026 at 09:02:48AM -0500, Andrew Dunstan wrote:
pushed with a slight tweak.
Having now reviewed commit 763aaa0, I don't think it's ready to remain part of
v19.  While some points from my v18 review are now resolved, other points
still seem unresolved.  I didn't find discussion of the unresolved points.  I
also see new issues.
OK, here's a reversion path. It's a bit messy, and I didn't touch the
release notes, but apart from that I think it does the right thing.
I checked "git diff 763aaa06f03^ src/bin/pg_dump/{*.c,*.h,t}" and I agree this
reverts everything.  Thanks for working through the revert.


Thanks for checking. Pushed with the release notes update.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com
--------------d7fRRZBKs3fs1TZHCm0bCtdS--