Re: su not working with psql

On Aug 18, 2009, at 12:00 PM, Tom Lane wrote:

> The PandaWare Company <lists(at)pandaware(dot)com> writes:
>> I'm running version 8.2 in Mac OS X 10.5.8. I installed it in a new
>> "postgres" user account. I can access it via PGAdmin and via a test
>> application I'm writing, both from my normal user account, "david". I
>> can also access it in the Terminal using psql when logged into the
>> postgres user account. But when I'm logged into my "david" account
>> and
>> try to access the database via sql I get the following:
>
>> imac:~ david$ su - postgres
>> Password:
>> imac:~ postgres$ psql fcddb
>> psql: FATAL: role "david" does not exist
>> imac:~ postgres$ whoami
>> postgres
>
> Huh. Do you have Kerberos credentials by any chance? I'm not sure
> if "su" would affect that.

Not that I'm aware of.