Re: Logging on without prompt for password

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(dot)rossi(at)us(dot)pgds(dot)com<mailto:maria(dot)rossi(at)us(dot)pgds(dot)com>
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099

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

2015-10-20 14:17 GMT-02:00 Glauco Torres <torres(dot)glauco(at)gmail(dot)com<mailto:torres(dot)glauco(at)gmail(dot)com>>:

2015-10-20 14:15 GMT-02:00 Rossi, Maria <maria(dot)rossi(at)jackson(dot)com<mailto:maria(dot)rossi(at)jackson(dot)com>>:

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?