Fwd: Logging on without prompt for password

OP decided to stop sending messages to the list....

---------- Forwarded message ----------
From: Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
Date: Tue, Oct 20, 2015 at 3:03 PM
Subject: RE: [ADMIN] Logging on without prompt for password
To: Glauco Torres <torres(dot)glauco(at)gmail(dot)com>
Cc: "scottm(at)openscg(dot)com" <scottm(at)openscg(dot)com>, "David G. Johnston" <
david(dot)g(dot)johnston(at)gmail(dot)com>

No, am not using pgbouncer

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(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 2:53 PM
*To:* Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
*Cc:* scottm(at)openscg(dot)com; David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
*Subject:* Re: [ADMIN] Logging on without prompt for password

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

Hi,

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