MIME-Version: 1.0
References: <3f22a8bb-29e8-40cc-97a1-309181da2c13@dunslane.net>
 <2bed001a-462c-42da-9a6b-3c7884502932@dunslane.net>
 <fd25e8b7-9538-4e44-90e5-8a357ac03eff@dunslane.net>
 <20250824010811.4d.nmisch@google.com>
 <82eb35b8-7f07-493b-b689-0934919e1dc3@dunslane.net>
 <CAKYtNAr+OMjcGKwd+AgWA+s=8EWGtg5PkVV3O7X6d3eCv=MUeQ@mail.gmail.com>
 <CAKYtNApzLLeCqt5fHDzZOTnzCdCnBt3Y_fytFmJ0LMNHDPY-yA@mail.gmail.com>
 <CAKYtNArSYJdjez541C0qPZ9R3_yzPDpScAd=-RU4kPRCJh4viQ@mail.gmail.com>
 <CAKYtNArGUTzrfTBxpftL_yAgkKE+hcDgXVfQvjB2HFO9rGhE5g@mail.gmail.com>
 <CA+vB=AEQc3Xqz+KMh35Zsa-SsRP-n=HXGT4RwwNou4-__Prx+A@mail.gmail.com>
 <CAKYtNAqJqDmKcqCzpHg2SO=2MTxvE7rOWCACsoWsO7520tUWKw@mail.gmail.com>
 <CA+vB=AE9ypeQV-hhXscJ6T75BrAFfZh56GX_eM=eVG2n1o_Beg@mail.gmail.com>
 <CA+vB=AGsn4eUxsbLk_oy=iKzd8D_1Ne375XH-2u6Zncu72Q01Q@mail.gmail.com>
 <CAKYtNAqQ5LHWNWyaeVOJaS=2xDJovfv9GShTBzf8_5s=jH7wsg@mail.gmail.com>
 <CAKYtNAoSTBqR24cn3XDOnwk2DCL+nAUkjpB5Xkz1H74rDqa-aQ@mail.gmail.com>
 <17555e46-4fb2-4265-90e0-95cb8ed584a6@dunslane.net>
 <CAKYtNAoz9JZC+-Uo4QsA1O0PkEehxhTFy1y3HJjqzv6jwrXvCQ@mail.gmail.com>
 <CA+vB=AETksQZpjyBosrZv6N5A6DjaCtMQop3+MB8GDj0XnYoxQ@mail.gmail.com>
 <CAKYtNAoEUvYEG207zaGY0pEh6TB2sk6hpuz9LdG-fYEC=e2CgQ@mail.gmail.com>
 <CAKYtNAppx6y7M+9Fb5+TtTNhRS6onZo9kHeQS6yQF7PiK6qnEA@mail.gmail.com>
 <CAC6VRoZie9-iC9gWcJs3QGx=2_tA34fMBmj7Ck0VAP2JpDJGug@mail.gmail.com>
 <CAC6VRoZHZWzHZ0Oh++WW=9Q83co4AyG6u4+7HVi1gJiuv1CZ2g@mail.gmail.com>
 <CAC6VRoYWPQZeLDuKVNeMz5z-iiVnv0zWyBwWhxdm4UQO17-AUQ@mail.gmail.com>
 <CAKYtNAoNi8O1wbSZx0a1oSi-YzQtprxqpfZqryRq39hXn_p-OA@mail.gmail.com>
 <CAC6VRoYCqJq=0q3GF+vfDVbY4JUehqsuxYhcmVi7A=1hfNzSJg@mail.gmail.com>
 <CAKYtNApm8nA6hVMNkSjeNPiwTZBWYkhJKU7haQghUZdw74tYxA@mail.gmail.com>
In-Reply-To: 
 <CAKYtNApm8nA6hVMNkSjeNPiwTZBWYkhJKU7haQghUZdw74tYxA@mail.gmail.com>
From: tushar <tushar.ahuja@enterprisedb.com>
Date: Wed, 10 Dec 2025 19:08:21 +0530
Message-ID: 
 <CAC6VRoaG8-3etBR-j1vrqW875-Y2847GAsCmGqxKcMAbmyeyhA@mail.gmail.com>
Subject: Re: Non-text mode for pg_dumpall
To: Mahendra Singh Thalor <mahi6run@gmail.com>
Cc: Vaibhav Dalvi <vaibhav.dalvi@enterprisedb.com>,
 pgsql-hackers@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000920640645992564"
Archived-At: 
 <https://www.postgresql.org/message-id/CAC6VRoaG8-3etBR-j1vrqW875-Y2847GAsCmGqxKcMAbmyeyhA%40mail.gmail.com>
Precedence: bulk

--0000000000000920640645992564
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Dec 9, 2025 at 12:18=E2=80=AFAM Mahendra Singh Thalor <mahi6run@gma=
il.com>
wrote:

> On Mon, 8 Dec 2025 at 22:39, tushar <tushar.ahuja@enterprisedb.com> wrote=
:
>
> Here, I am attaching an updated patch for the review and testing. This
> can be applied on commit d0d0ba6cf66c4043501f6f7.
>
>
Thanks, Mahendra, please refer to this scenario where  if
"--transaction-size" switch  is used with pg_dumpall/pg_restore, then the
table creation fails (or the table is not created)

Steps to reproduce:
1. Connect to the psql terminal, create a table/insert rows { create table
t(n int); insert into t values (generate_series(1,15)); }
2. Perform pg_dump operation  { ./pg_dumpall -Ft -f tar.dump }
3. new cluster:
try to restore with  --transaction-size switch { ./pg_restore -Ft  tar.dump
 -C -d postgres   --transaction-size=3D10 } =3D  Table failed to create

I have checked via pg_dump/pg_restore using --transaction-size, and it is
working fine, i.e, table is created successfully

./pg_dump -Ft -f tar.d postgres
./pg_restore  --transaction-size=3D10 -Ft -d new_database  tar.d

regards,

--0000000000000920640645992564
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Dec 9, =
2025 at 12:18=E2=80=AFAM Mahendra Singh Thalor &lt;<a href=3D"mailto:mahi6r=
un@gmail.com">mahi6run@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">On Mon, 8 Dec 2025 at 22:39, tushar &lt;<a=
 href=3D"mailto:tushar.ahuja@enterprisedb.com" target=3D"_blank">tushar.ahu=
ja@enterprisedb.com</a>&gt; wrote:<br><br>
Here, I am attaching an updated patch for the review and testing. This<br>
can be applied on commit d0d0ba6cf66c4043501f6f7.<br><br></blockquote><div>=
<br></div><div>Thanks, Mahendra, please refer to this scenario where =C2=A0=
if &quot;--transaction-size&quot; switch =C2=A0is used with pg_dumpall/pg_r=
estore, then the table creation fails (or the table is not created)=C2=A0</=
div><div class=3D"gmail_quote gmail_quote_container"><br></div>Steps to rep=
roduce: <br>1. Connect to the psql terminal, create a table/insert rows { c=
reate table t(n int); insert into t values (generate_series(1,15)); }<br>2.=
 Perform pg_dump operation =C2=A0{ ./pg_dumpall -Ft -f tar.dump }<br>3. new=
 cluster:<br>try to restore with =C2=A0--transaction-size switch { ./pg_res=
tore -Ft =C2=A0tar.dump =C2=A0-C -d postgres =C2=A0 --transaction-size=3D10=
 } =3D =C2=A0Table failed to create=C2=A0<br><br>I have checked via pg_dump=
/pg_restore using --transaction-size, and it is working fine, i.e, table is=
 created successfully<br>=C2=A0<br>./pg_dump -Ft -f tar.d postgres<br>./pg_=
restore =C2=A0--transaction-size=3D10 -Ft -d new_database =C2=A0tar.d<br></=
div><div class=3D"gmail_quote gmail_quote_container"><br></div><div class=
=3D"gmail_quote gmail_quote_container">regards,</div><div class=3D"gmail_qu=
ote gmail_quote_container"><br></div><div class=3D"gmail_quote gmail_quote_=
container"><br></div></div>

--0000000000000920640645992564--