Re: Logging on without prompt for password

Here’s what the automated discovery is using:

/usr/pgsql-9.3/bin/pg_dumpall" -U bmcap01 -s -x

And it got this error:
pg_dumpall: could not connect to database "template1": could not connect to server: No such file or directory
Then, I retried the pg_dumpall with the –p (for port#) and it prompted for the password.

Thanks.

Maria A Rossi
Database Administration
PGDS (US)
email: maria(dot)rossi(at)jackson(dot)com
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099

From: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Sent: Tuesday, October 20, 2015 12:07 PM
To: Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Logging on without prompt for password

On Tue, Oct 20, 2015 at 10:38 AM, Rossi, Maria <maria(dot)rossi(at)jackson(dot)com<mailto:maria(dot)rossi(at)jackson(dot)com>> wrote:

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.​

​David J.
​