Subject: Re: Non-text mode for pg_dumpall

From: tushar <[email-masked]>
Date: Mon, 12 Jan 2026 13:39:20 +0530

On Tue, Jan 6, 2026 at 11:56 AM Mahendra Singh Thalor <[email-masked]>
wrote:

>
> Here, I am attaching an updated patch for the review and testing.
>
> Note: some of the review comments are still not fixed. I am working on
> those and will post an updated patch.
>
> Hi Mahendra,
Please refer this scenario - if we are using with "--jobs" switch then
getting an error at the time of restore

Create a table (  create table t(n int); insert into t values (1);  )
Perform pg_dumpall ( ./pg_dumpall -Fd -f abc1.dr )
Create a new cluster, start the server against a different port
Perform pg_restore using switch "--jobs 4 " (./pg_restore -j 4 -d postgres
abc1.dr/  -p 9000 -C )

"
[edb@1a1c15437e7c bin]$ ./pg_restore -j 4 -d postgres abc1.dr/  -p 9000 -C
pg_restore: error: could not execute query: ERROR:  role "edb" already
exists
Command was: CREATE ROLE edb;
ALTER ROLE edb WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION
BYPASSRLS;

pg_restore: error: could not execute query: ERROR:  syntax error at or near
"\"
LINE 1: \connect template1
        ^
Command was: \connect template1

pg_restore: error: could not execute query: ERROR:  syntax error at or near
"\"
LINE 1: \connect postgres
        ^
Command was: \connect postgres

pg_restore: warning: errors ignored on restore: 3
[edb@1a1c15437e7c bin]$
"

regards,