Re: Curious case of the unstoppable user

On 03/29/2011 01:32 PM, Thom Brown wrote:
> On 29 March 2011 21:28, hubert depesz lubaczewski<depesz(at)depesz(dot)com> wrote:
>> On Tue, Mar 29, 2011 at 07:44:51PM +0100, Thom Brown wrote:
>>> So, I'm overlooking something. Could someone tell me what it is? I
>>> bet it's something obvious. I'm using 9.1dev if it's relevant.
>>
>> perhaps meow is superuser?
>
> stuff=> \dg+
> List of roles
> Role name | Attributes | Member
> of | Description
> -----------+------------------------------------------------+-----------+-------------
> meow | | {} |
> testrole | Cannot login | {} |
> thom | Superuser, Create role, Create DB, Replication | {} |
>

My guess is you have pg_hba.conf set up to use trust for the connection.
In your original example testrole failed because it is not a login role
not for permissions reasons. When \c to stuff as meow can you do \d?

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com