On Tue, Jan 6, 2026 at 11:56 AM Mahendra Singh Thalor <[email protected]>
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,
