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