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