| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Steven Hirsch <snhirsch(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Cannot drop role |
| Date: | 2017-02-13 18:48:50 |
| Message-ID: | 20170213184850.e2diqg3jk2uyfmvu@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Barwick | 2017-02-14 01:55:09 | Re: repmgr error with automated failover |
| Previous Message | Steven Hirsch | 2017-02-13 18:43:10 | Cannot drop role |