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@us.pgds.com
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099
From: Glauco Torres [mailto:torres.glauco@gmail.com]
Sent: Tuesday, October 20, 2015 12:19 PM
To: Rossi, Maria <maria.rossi@jackson.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Logging on without prompt for password
2015-10-20 14:17 GMT-02:00 Glauco Torres <torres.glauco@gmail.com>:
2015-10-20 14:15 GMT-02:00 Rossi, Maria <maria.rossi@jackson.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.