Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46299=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cdLgJ-0003m1-89
	for pgsql-admin@arkaria.postgresql.org; Mon, 13 Feb 2017 18:48:59 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46299=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cdLgI-0002Wg-Le
	for pgsql-admin@arkaria.postgresql.org; Mon, 13 Feb 2017 18:48:58 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1cdLgH-0002UX-Rn
	for pgsql-admin@postgresql.org; Mon, 13 Feb 2017 18:48:58 +0000
Received: from mail-qk0-x232.google.com ([2607:f8b0:400d:c09::232])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1cdLgE-0002NA-Av
	for pgsql-admin@postgresql.org; Mon, 13 Feb 2017 18:48:56 +0000
Received: by mail-qk0-x232.google.com with SMTP id p22so10517606qka.0
        for <pgsql-admin@postgresql.org>;
 Mon, 13 Feb 2017 10:48:54 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=ogyNfVKv5JmD3WphOPKnj1JwZ6m53VEMpwMdL8fl1NY=;
        b=ELHH5PL8BtgVTacB7OvZd6p8uVyvjcdXH8WS9zJcJayqovktuXeWtAN61FeWbDNmFd
         q8KBce6q6xPmXwtQfZzg6HQFApGGqp5vvUc83SshGHUaFEhEqsyRiSQQddL2BF7FgkC8
         LN6CNTyvUzeeyARKNitsOtTU0RF6RbUaO05/dbYysH6CEGqQAsP/2hLau0aaEY4DilVl
         AcJ8UX2wGqxlAJszO/DN96v3xWwbufgC6bQ4QPGqAQ+V7pdBlbZa4iJpbQ67dkoGD4qi
         NUqO68IWfIeeG/zD2Pnpa3GPL9uW0r36DgQXMquUswKjGfASfTq4avpLzHVcgxO4xOom
         Fqxg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=ogyNfVKv5JmD3WphOPKnj1JwZ6m53VEMpwMdL8fl1NY=;
        b=QPNcXC6mqoVdfyN1/6VHMk/hSEu0BZmCesz2Uq2pMMhx3dwASt/Z5Ojw8XWN8gnLqe
         1XEcclzy/1WTlonSSwESbh+nckCUFiKRFgC7HH4r4M4eAiOIV9Aj6tRm2guOQOMyz16l
         vP3SQDkb6Raydk5zbV9joXbSvIZCeF6rOhEh1IAZNpvCu808RbUNIditm73UESOLPmom
         Kmn+ua80U6g+ZBB8ntGmU0tfJKRP1P0aq9oB5rvYGS+qTEfE6V5k8E140ZRuyLthFLPY
         yL4hwcmmYG6N2SxpgtkHi2tqLSkFqdJKTDi+L7B8EOwklKTw1/YYmAjxo9Up4Hc3npNH
         zqHA==
X-Gm-Message-State: 
 AMke39lyIX3vF3BBQ8qlNzsQjVTkR71M9i8NCb6d6/AjD3YU13lWJlhEJ2UJLTsELS3HqgS6
X-Received: by 10.55.113.193 with SMTP id m184mr22457392qkc.57.1487011733152;
        Mon, 13 Feb 2017 10:48:53 -0800 (PST)
Received: from alvin.alvh.no-ip.org ([190.217.211.239])
        by smtp.gmail.com with ESMTPSA id
 m27sm8059429qtf.19.2017.02.13.10.48.52
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Mon, 13 Feb 2017 10:48:52 -0800 (PST)
Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000)
	id CB8918D4; Mon, 13 Feb 2017 15:48:50 -0300 (CLST)
Date: Mon, 13 Feb 2017 15:48:50 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Steven Hirsch <snhirsch@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Cannot drop role
Message-ID: <20170213184850.e2diqg3jk2uyfmvu@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <alpine.DEB.2.20.1702131336020.4109@z87>
User-Agent: NeoMutt/20170113 (1.7.2)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin