From: Rossi, Maria <maria.rossi@xxxxxxxxxxx>
Date: Tue, Oct 20, 2015 at 3:03 PM
Subject: RE: [ADMIN] Logging on without prompt for password
To: Glauco Torres <torres.glauco@xxxxxxxxx>
Cc: "scottm@xxxxxxxxxxx" <scottm@xxxxxxxxxxx>, "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Pg_dumpall is running with in the server
Here’s a portion of my pg_hba.conf
host all bmcap01 127.0.0.1/32 trust
host all psgdba 127.0.0.1/32 trust
I tried this one, this is working: (ye-hey!!)
pg_dumpall -p 40101 -h 127.0.0.1 -U psgdba
Thank you again.
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 2:53 PM
To: Rossi, Maria <maria.rossi@xxxxxxxxxxx>
Cc: scottm@xxxxxxxxxxx; David G. Johnston <david.g.johnston@xxxxxxxxx>
Subject: Re: Logging on without prompt for password
2015-10-20 16:44 GMT-02:00 Rossi, Maria <maria.rossi@xxxxxxxxxxx>:
Back to my original question, though. Any ideas why it is still prompting for password even though it had ‘trust’ in the pg_hba.conf? The .pgpass or the PGPASSWORD is only a work-around for that, I think. ‘Trust’ is supposed to:
Allow the connection unconditionally. This method allows anyone that can connect to the PostgreSQL database server to login as any PostgreSQL user they wish, without the need for a password or any other authentication
So, I shouldn’t need to set-up .pgpass or PGPASSWORD.
Any thoughts?
Do you use any connection pool (pgbouncer)?
Pg_dumpall command is being running within the server? or you are connecting to another machine?
The best is you pass the command that you are running and also show your pg_hba.conf
if you are running from within the own server and want to let the pg_hba in trust for local connections
your pg_hba.conf this like this?
# Socket and localhost
place all all trust
host all all 127.0.0.1/32 trust
Remember you have to connect the port of the postmaster
pg_dumpall -p 5432 -h 127.0.0.1 -U postgres
Regards,
Glauco Torres
