Re: su not working with psql

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.

regards, tom lane