Postgres Pro
Downloads
Home   >   mailing lists

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

From Rushabh Lathia
Subject Re: Error during restore - dump taken with pg_dumpall -c option
Date
Msg-id CAGPqQf2jM5YWb5X-RXDeoSwkSAUqokn8OJMUeAmLQA71FPSrxQ@mail.gmail.com
Whole thread Raw
In response to Re: Error during restore - dump taken with pg_dumpall -c option  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Error during restore - dump taken with pg_dumpall -c option  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tree view


On Fri, May 13, 2016 at 7:27 PM, Stephen Frost <sfrost@snowman.net> wrote:
* 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!


Thanks Stephen.

pgsql-hackers by date:

Previous
From: Pete Hollobon
Date:
Subject: Re: [PATCH] Add EXPLAIN (ALL) shorthand
Next
From: Andres Freund
Date:
Subject: 9.4 failure on skink in _bt_newroot/XLogCheckBuffer