this my configuration:
#postgres.conf: listen_addresses = 'localhost' #pg_hba.conf: local all postgres md5 local all appuser trust local all devuser trust local all all peer
i'm connecting in local using the C-Library
My connection string is:
host=localhost user=appuser dbname=mydbname port='5432'
However, unless I have a .pgpass file in the home of my developer user (devuser), (the one who launches the application that is linked with libpq), my executable cannot connect, I receive the error
fe_sendauth : no password supplied
As I said, if the .pgpass file is here, then it connects ok.
What I don't understand: I configured
local all appuser trust.
Why do I need a .pgpass file all the same?
(It's not a serious problem in itself, because later on for security measure, it will no longer be at
md5, so I'll have the .pgpass file anyway. But I'd like to know)