Request a Demo
Home   >   mailing lists

Re: Non-text mode for pg_dumpall - Mailing list pgsql-hackers

From tushar
Subject Re: Non-text mode for pg_dumpall
Date
Msg-id CAC6VRobwTFokpZCpnDBh3fRHYTAcFeKvPiopLk_Dvc-tbtWsvg@mail.gmail.com
Whole thread Raw
In response to Re: Non-text mode for pg_dumpall  (Mahendra Singh Thalor <mahi6run@gmail.com>)
List pgsql-hackers
Tree view


On Tue, Jan 6, 2026 at 11:56 AM Mahendra Singh Thalor <mahi6run@gmail.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@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,

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Remaining dependency on setlocale()
Next
From: jian he
Date:
Subject: Re: JumbleQuery ma treat different GROUP BY expr as the same