su not working with psql

From: The PandaWare Company <lists(at)pandaware(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: su not working with psql
Date: 2009-08-18 18:11:47
Message-ID: B9884D2D-8A5E-4B4C-8EAE-7C0BE7E580CF@pandaware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm new to this list and new to PostgreSQL, so I hope this question
isn't off-base.

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

I wonder if anybody has any idea what's going wrong? The system
appears to correctly see me as postgres after using the su command, as
evidenced by the response to whoami. But somehow the PostgreSQL
process or psql is seeing me as "david". I have tested to see if
creating a role for david in the database solves this problem, and it
does. But I'm concerned that there's something fundamentally wrong
here that needs to be addressed.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-08-18 19:00:16 Re: su not working with psql
Previous Message Sean Davis 2009-08-18 15:07:52 Re: Count the children