Skip site navigation (1) Skip section navigation (2)

Re: su not working with psql

From: The PandaWare Company <lists(at)pandaware(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: su not working with psql
Date: 2009-08-18 20:06:25
Message-ID: BBDA1FC6-61BF-4F02-A9D2-4971B695DF9E@pandaware.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

In response to

Responses

pgsql-novice by date

Next:From: Bob McConnellDate: 2009-08-18 20:40:53
Subject: Re: Platform for running Postgres 8.4
Previous:From: Tom LaneDate: 2009-08-18 19:00:16
Subject: Re: su not working with psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group