Re: md5 and trust and pg_hba.conf
Sameer Kumar <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <CADp-Sm446qLaiwW70SCykX-T_BMfd7kuUQgTey=u2mSDr6o=Kw@mail.gmail.com> |
On Mon, Sep 10, 2018 at 10:46 PM Rossi, Maria <[email protected]> wrote: > Hi, > > > > Question on pg_hba.conf. I have these entries: > > > > host all psgdba localhost trust > > host all psgdba 127.0.0.1/32 trust > > host all gd07 localhost trust > > host all gd07 127.0.0.1/32 trust > > > Can you post the whole of pg_hba.conf file? You might have some other entry that is taking precedence. > > > Command to logon to Postgres: > > /usr/pgsql-9.3/bin/psql -d postgres > If you don't have PGHOST set then most likely you are not going over a tcp connection (which is what host entries in pg_hba are used for). Instead the local entries of pg_hba are taking effect. > > If I am logged on ‘gd07’ at the server , it lets me log-on to Postgres > without prompting for password > do you have a *.pgpass* file in the home directory? > If I am logged on as ‘psgdba’, it prompts for password. > > As you can see, both have ‘trust’, but ‘gd07’ is the instance owner. > > > > Why does ‘psgdba’ prompts? What I am missing? > > Your help would be much appreciated. > > > > Thanks. > > Maria > > > -- -- Best Regards, *Sameer Kumar | Senior Solution Architect* *ASHNIK PTE. LTD.* 36 Robinson Road, #14-04 City House, Singapore 068877 T: +65 6438 3504 | www.ashnik.com Skype: sameer.ashnik | M: +65 8110 0350