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
>>> file that's selecting userid david? Unless "su" is behaving
>>> 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
> ls -l ~/.pgpass
> cat ~/.pgpass
As I mentioned earlier, after the su - postgres command, whoami
ls -l ~/.pgpass returns:
ls: /Users/postgres/.pgpass: No such file or directory
In response to
pgsql-novice by date
|Next:||From: Michael Rowan||Date: 2009-08-19 00:12:06|
|Subject: Re: Count the children|
|Previous:||From: Frank Bax||Date: 2009-08-18 22:41:19|
|Subject: Re: su not working with psql|