Re: su not working with psql

On Aug 18, 2009, at 3:41 PM, Frank Bax wrote:

> 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

As I mentioned earlier, after the su - postgres command, whoami
returned "postgres".

ls -l ~/.pgpass returns:

ls: /Users/postgres/.pgpass: No such file or directory