Fwd: Logging on without prompt for password

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------- Forwarded message ----------
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>


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.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>:

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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux