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>
 <CAC6VRoaG8-3etBR-j1vrqW875-Y2847GAsCmGqxKcMAbmyeyhA@mail.gmail.com>
 <CAKYtNAryvnS15DKdE-4QdiYeR1XKwz0RrOnsaNL72G5ubmn_hw@mail.gmail.com>
In-Reply-To: 
 <CAKYtNAryvnS15DKdE-4QdiYeR1XKwz0RrOnsaNL72G5ubmn_hw@mail.gmail.com>
From: tushar <tushar.ahuja@enterprisedb.com>
Date: Fri, 12 Dec 2025 19:10:02 +0530
Message-ID: 
 <CAC6VRoY6Vpm01hOnp2F=gyNt_f6rCz9kuESmgP524mQnruEVJQ@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="000000000000bbc9b50645c1663b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAC6VRoY6Vpm01hOnp2F%3DgyNt_f6rCz9kuESmgP524mQnruEVJQ%40mail.gmail.com>
Precedence: bulk

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

On Thu, Dec 11, 2025 at 9:39=E2=80=AFPM Mahendra Singh Thalor <mahi6run@gma=
il.com>
wrote:

>
>
> Here, in our case, as the cluster already has a role with the current
> user in restore, we are reporting error  "pg_restore: error: could not
> execute query: ERROR:  role "role" already exists" and after this
> error, restore is exiting.
>
> If you restore using a different role, then you will not get any error
> and the full cluster will be restored. I will add some handling to
> ignore the "CREATE ROLE current_user" command in pg_restore.
>
> Thanks Mahendra, Could you please also add some error message  for this
below
pg_restore command:
postgres=3D# create table t(n int);
CREATE TABLE
postgres=3D# insert into t values (1),(10),(100);
INSERT 0 3
Perform pg_dump: ./pg_dump -Ft   -f a.a1  postgres
Perform pg_restore: /pg_restore  -Ft  a.a1 -f  -C -v
pg_restore: creating TABLE "public.t"
pg_restore: processing data for table "public.t"
[edb@1a1c15437e7c bin]$ ./psql postgres
psql (19devel)
Type "help" for help.
postgres=3D# \dt
Did not find any tables.
postgres=3D#

regards,

--000000000000bbc9b50645c1663b
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 Thu, Dec 11,=
 2025 at 9:39=E2=80=AFPM 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"><br>
<br>
Here, in our case, as the cluster already has a role with the current<br>
user in restore, we are reporting error=C2=A0 &quot;pg_restore: error: coul=
d not<br>
execute query: ERROR:=C2=A0 role &quot;role&quot; already exists&quot; and =
after this<br>
error, restore is exiting.<br>
<br>
If you restore using a different role, then you will not get any error<br>
and the full cluster will be restored. I will add some handling to<br>
ignore the &quot;CREATE ROLE current_user&quot; command in pg_restore.<br><=
br></blockquote><div>Thanks Mahendra, Could you please also add some error =
message=C2=A0 for this below=C2=A0</div><div>pg_restore command:</div><div>=
postgres=3D# create table t(n int);</div>CREATE TABLE<br>postgres=3D# inser=
t into t values (1),(10),(100);<br>INSERT 0 3</div><div class=3D"gmail_quot=
e gmail_quote_container">Perform=C2=A0pg_dump: ./pg_dump -Ft =C2=A0 -f a.a1=
 =C2=A0postgres<br></div><div class=3D"gmail_quote gmail_quote_container">P=
erform=C2=A0pg_restore: /pg_restore =C2=A0-Ft =C2=A0a.a1 -f =C2=A0-C -v<br>=
pg_restore: creating TABLE &quot;public.t&quot;<br>pg_restore: processing d=
ata for table &quot;public.t&quot;<br>[edb@1a1c15437e7c bin]$ ./psql postgr=
es <br>psql (19devel)<br>Type &quot;help&quot; for help.<br>postgres=3D# \d=
t<br>Did not find any tables.<br>postgres=3D#=C2=A0<br></div><div class=3D"=
gmail_quote gmail_quote_container"><br></div><div class=3D"gmail_quote gmai=
l_quote_container">regards,</div><div class=3D"gmail_quote gmail_quote_cont=
ainer"><br></div></div>

--000000000000bbc9b50645c1663b--