Re: su not working with psql

On Aug 18, 2009, at 3:17 PM, 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.

Correction:

I forgot to mention that the listing for the old project does not even
have "david" in its content.

And, there is also a listing for a connection to localhost, but it too
lacks any mention of "david".