Postgres Pro
Downloads
Home   >   mailing lists

Re: Error during restore - dump taken with pg_dumpall -c option - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Error during restore - dump taken with pg_dumpall -c option
Date
Msg-id 20160513135757.GU10850@tamriel.snowman.net
Whole thread Raw
In response to Error during restore - dump taken with pg_dumpall -c option  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Responses Re: Error during restore - dump taken with pg_dumpall -c option  (Rushabh Lathia <rushabh.lathia@gmail.com>)
List pgsql-hackers
Tree view 
* Rushabh Lathia (rushabh.lathia@gmail.com) wrote:
> On master branch when we do pg_dumpall with -c option, I can see that
> it also dumping the "DROP ROLE pg_signal_backend", which seems wrong.
> Because when you restore the dump, its throwing an error
> "ERROR:  cannot drop role pg_signal_backend because it is required by the
> database system".

Ah, yes, dropRoles() needs the same change that dumpRoles() got.

Will fix, thanks!

Stephen

pgsql-hackers by date:

Previous
From: Ashutosh Sharma
Date:
Subject: Re: Perf Benchmarking and regression.
Next
From: Robert Haas
Date:
Subject: Re: Postgres_fdw join pushdown - getting server crash in left outer join of three table