From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
---|---|
To: | "Rossi, Maria" <maria(dot)rossi(at)jackson(dot)com> |
Cc: | "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>, "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
Subject: | Re: md5 and trust and pg_hba.conf |
Date: | 2018-09-10 14:55:26 |
Message-ID: | CADp-Sm446qLaiwW70SCykX-T_BMfd7kuUQgTey=u2mSDr6o=Kw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
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-04 City House, Singapore 068877
T: +65 6438 3504 | www.ashnik.com
Skype: sameer.ashnik | M: +65 8110 0350
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Pardi | 2018-09-10 15:17:47 | Re: md5 and trust and pg_hba.conf |
Previous Message | Rossi, Maria | 2018-09-10 14:45:38 | md5 and trust and pg_hba.conf |
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Pardi | 2018-09-10 15:17:47 | Re: md5 and trust and pg_hba.conf |
Previous Message | Rossi, Maria | 2018-09-10 14:45:38 | md5 and trust and pg_hba.conf |