Re: Non-text mode for pg_dumpall

On Tue, Jan 6, 2026 at 11:56 AM Mahendra Singh Thalor <mahi6run(at)gmail(dot)com>
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(at)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(at)1a1c15437e7c bin]$
"

regards,