Re: md5 and trust and pg_hba.conf

On Mon, Sep 10, 2018 at 11:22 PM Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
wrote:

> Both have PGHOST set. gd07 has a .pgpass, but psgdba does not.
>

What is it set to?

Can you post the rest of the pg_hba.conf?

> Does it still need a .pgpass even if it is already ‘trust’?
>

It should not.

> Thanks.
>
>
>
>
>
> *Maria A Rossi*
>
> Database Administration
>
> Jackson National Life
>
> email: maria(dot)rossi(at)jackson(dot)com
> cell phone: 517.256.4392
>
> work phone: 517.367.3099
> work phone extension: 23099
>
>
>
> *From:* Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
> *Sent:* Monday, September 10, 2018 10:55 AM
> *To:* Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
> *Cc:* pgsql-sql(at)lists(dot)postgresql(dot)org; pgsql-novice(at)lists(dot)postgresql(dot)org
> *Subject:* Re: md5 and trust and pg_hba.conf
>
>
>
> *EXTERNAL EMAIL*
>
>
>
> On Mon, Sep 10, 2018 at 10:46 PM Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
> 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
> <https://maps.google.com/?q=36+Robinson+Road,+%2314&entry=gmail&source=g>-04
> City House, Singapore 068877
>
> T: +65 6438 3504 <6438%203504> | www.ashnik.com
>
> Skype: sameer.ashnik | M: +65 8110 0350 <8110%200350>
>
> [image: ~WRD000.jpg]
>
> --

--

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