Re: su not working with psql

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