Re: [ADMIN] Cannot drop role - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: [ADMIN] Cannot drop role
Date
Msg-id 20170213184850.e2diqg3jk2uyfmvu@alvherre.pgsql
Whole thread Raw
In response to [ADMIN] Cannot drop role  (Steven Hirsch <snhirsch@gmail.com>)
List pgsql-admin
Steven Hirsch wrote:

> At this point I suspect there's something corrupted in the system catalog.

Yes, clearly.

> How can I find the table entry (or entries) that reference that identifier?
> The fact that the message is issued suggests a link somewhere but I cannot
> locate it.

Look in pg_shdepend.  Probably somebody deleted rows from pg_default_acl
(and who knows what else) rather than using DDL commands, which is what
they should have done.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-admin by date:

Previous
From: Steven Hirsch
Date:
Subject: [ADMIN] Cannot drop role
Next
From: Ian Barwick
Date:
Subject: Re: [ADMIN] repmgr error with automated failover