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

Re: su not working with psql

From: Carol Walter <walterc(at)indiana(dot)edu>
Cc: The PandaWare Company <lists(at)pandaware(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: su not working with psql
Date: 2009-08-19 12:46:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I've had su behave in strange ways if the numeric UID was not set the  
same on all systems.  We use Solaris so I don't know if this problem  
would exist in other systems.  We also use ldap.  What happens is that  
postgres comes bundled with Solaris.  We use ldap so we have a  
systemwide postgres user.  The Solaris install also creates a local  
postgres user.  Since the system reads the local password file first,  
that's the user that it gets.  Going across systems causes real  
problems, if you don't correct the discrepancy.


On Aug 18, 2009, at 5:57 PM, Tom Lane wrote:

> The PandaWare Company <lists(at)pandaware(dot)com> writes:
>> local   all         all                               trust
> OK, that eliminates another possibility (that ident was doing  
> something
> weird).
> 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 ...
> 			regards, tom lane
> -- 
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:

In response to

pgsql-novice by date

Next:From: LesterDate: 2009-08-19 18:37:00
Subject: HELP! Data needed out of pgsql!
Previous:From: Mike EllsworthDate: 2009-08-19 11:41:19
Subject: Re: text records and cross referencing

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