psql asks for password despite configuring trust authentication from localhost
Solution 1:
There were other settings in there for local and IPv6 connections which were not trust. I made them all trust and it works now. So it looks like psql doesn't connect via IPv4.