Re: Logging on without prompt for password

["Rossi, Maria" <maria.rossi@xxxxxxxxxxx>]

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.rossi@xxxxxxxxxxx
cell phone: 517.256.4392

work phone: 517.367.3099
work phone extension: 23099

 

From: David G. Johnston [mailto:david.g.johnston@xxxxxxxxx]
Sent: Tuesday, October 20, 2015 12:07 PM
To: Rossi, Maria <maria.rossi@xxxxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [ADMIN] Logging on without prompt for password

 

On Tue, Oct 20, 2015 at 10:38 AM, Rossi, Maria <maria.rossi@xxxxxxxxxxx> 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.

​