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.
Carol
On Aug 18, 2009, at 5:57 PM, Tom Lane wrote:
> The PandaWare Company <lists@pandaware.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice