Re: Error during restore - dump taken with pg_dumpall -c option

From: Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Error during restore - dump taken with pg_dumpall -c option
Date: 2016-05-21 18:26:14
Message-ID: CAGPqQf2jM5YWb5X-RXDeoSwkSAUqokn8OJMUeAmLQA71FPSrxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, May 13, 2016 at 7:27 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:

> * Rushabh Lathia (rushabh(dot)lathia(at)gmail(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2016-05-21 20:31:01 9.4 failure on skink in _bt_newroot/XLogCheckBuffer
Previous Message Pete Hollobon 2016-05-21 18:01:14 Re: [PATCH] Add EXPLAIN (ALL) shorthand