Re: su not working with psql

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: su not working with psql
Date: 2009-08-18 22:41:19
Message-ID: 4A8B2E0F.9060706@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

The PandaWare Company wrote:
> On Aug 18, 2009, at 2:57 PM, Tom Lane wrote:
>
>> I just thought of another theory, though --- maybe you have a ~/.pgpass
>> file that's selecting userid david? Unless "su" is behaving differently
>> than it seems to here, that would be in postgres' home directory not
>> david's, but you might have copied david's file ...
>
> Using the "locate" command in Terminal, the only one I see is in david's
> home directory. It has an entry for a remote server, in connection with
> a project I worked on briefly some months ago.
>

locate does not include recently created files.

What is the output of:
su - postgres
whoami
ls -l ~/.pgpass
cat ~/.pgpass

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message The PandaWare Company 2009-08-18 22:46:23 Re: su not working with psql
Previous Message Tom Lane 2009-08-18 22:37:34 Re: su not working with psql