Is there a way of enabling a user to logon without being prompted for password? I know there is the .pgpass file, but this file requires the port# and my server has several postgres clusters with different port#. So, am not sure if I can use the .pgpass file.
In this situation you would have a single line for each cluster in the .pgpass file.
And at the pg_hba.conf file, the id already has ‘trust’ method, but it is still being prompted for password.
We can give better advice if you provide the command line invocations you are using.