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

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

* 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!

Stephen

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-05-13 14:14:40 Re: Postgres_fdw join pushdown - getting server crash in left outer join of three table
Previous Message Ashutosh Sharma 2016-05-13 11:08:51 Re: Perf Benchmarking and regression.