Re: su not working with psql - Mailing list pgsql-novice

From The PandaWare Company
Subject Re: su not working with psql
Date
Msg-id BBDA1FC6-61BF-4F02-A9D2-4971B695DF9E@pandaware.com
Whole thread Raw
In response to Re: su not working with psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: su not working with psql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Aug 18, 2009, at 12:00 PM, Tom Lane wrote:

> The PandaWare Company <lists@pandaware.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.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: su not working with psql
Next
From: Bob McConnell
Date:
Subject: Re: Platform for running Postgres 8.4