Re: Logging on without prompt for password

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

Hi,

 

We will  try the .pgpass file at the user’s home directory, using *.* for port  as suggested by Scott Mead.    This way I don’t  have to worry about setting the  PGPASSWORD env var for the user.

 

I still need to create a role for the user, correct?  It needs admin to be able to rung pg_dumpall.

 

Thanks everyone.

 

 

 

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: Glauco Torres [mailto:torres.glauco@xxxxxxxxx]
Sent: Tuesday, October 20, 2015 12:19 PM
To: Rossi, Maria <maria.rossi@xxxxxxxxxxx>
Cc: David G. Johnston <david.g.johnston@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [ADMIN] Logging on without prompt for password

 

 

 

2015-10-20 14:17 GMT-02:00 Glauco Torres <torres.glauco@xxxxxxxxx>:

 

 

2015-10-20 14:15 GMT-02:00 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.

 

 

 

Are you using pgbouncer?