Skip site navigation (1) Skip section navigation (2)

Re: su not working with psql

From: The PandaWare Company <lists(at)pandaware(dot)com>
To: Frank Bax <fbax(at)sympatico(dot)ca>
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: su not working with psql
Date: 2009-08-18 22:46:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Michael RowanDate: 2009-08-19 00:12:06
Subject: Re: Count the children
Previous:From: Frank BaxDate: 2009-08-18 22:41:19
Subject: Re: su not working with psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group