agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rossi, Maria <maria.rossi@jackson.com>
To: Sameer Kumar <sameer.kumar@ashnik.com>
Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: RE: md5 and trust and pg_hba.conf
Date: Mon, 10 Sep 2018 19:47:04 +0000
Message-ID: <7974b8ff73cc4119804e0e8c8f900a26@DC03PXMBP003.jacksonnational.com> (raw)
In-Reply-To: <CADp-Sm4qBwxXuWrOK-KuNiY0XPt-2-5hbDLCfR3bprcfdM7YUA@mail.gmail.com>
References: <daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com>
<CADp-Sm446qLaiwW70SCykX-T_BMfd7kuUQgTey=u2mSDr6o=Kw@mail.gmail.com>
<539851b398294c5994ee8c425c3710ac@DC03PXMBP003.jacksonnational.com>
<CADp-Sm4qBwxXuWrOK-KuNiY0XPt-2-5hbDLCfR3bprcfdM7YUA@mail.gmail.com>
Hi,
I think, I got it . Thanks for pointing me to the right direction.
Here’s the correct partial pg_hba.conf
host all psgdba localhost trust
host all psgdba 127.0.0.1/32 trust
host all psgdba 10.8.88.141/32 trust
host all psgdba all md5
host all gd07 localhost trust
host all gd07 127.0.0.1/32 trust
host all gd07 10.8.88.141/32 trust
host all gd07 all md5
This line below used to be there. This is the IP of the server. I deleted it and added a ‘trust’ line for psgdba and gd07
host all all 10.8.88.141/32 md5
Works now. Thanks for your help
Sorry for hesitating to post the entire pg_hba.conf.
Thanks again.
Maria
From: Sameer Kumar <sameer.kumar@ashnik.com>
Sent: Monday, September 10, 2018 11:35 AM
To: Rossi, Maria <maria.rossi@jackson.com>
Cc: pgsql-sql@lists.postgresql.org; pgsql-novice@lists.postgresql.org
Subject: Re: md5 and trust and pg_hba.conf
EXTERNAL EMAIL
On Mon, Sep 10, 2018 at 11:22 PM Rossi, Maria <maria.rossi@jackson.com<mailto:maria.rossi@jackson.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.
From: Sameer Kumar <sameer.kumar@ashnik.com<mailto:sameer.kumar@ashnik.com>>
Sent: Monday, September 10, 2018 10:55 AM
To: Rossi, Maria <maria.rossi@jackson.com<mailto:maria.rossi@jackson.com>>
Cc: pgsql-sql@lists.postgresql.org<mailto:pgsql-sql@lists.postgresql.org>; pgsql-novice@lists.postgresql.org<mailto:pgsql-novice@lists.postgresql.org>
Subject: Re: md5 and trust and pg_hba.conf
EXTERNAL EMAIL
On Mon, Sep 10, 2018 at 10:46 PM Rossi, Maria <maria.rossi@jackson.com<mailto:maria.rossi@jackson.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<http://127.0.0.1/32; trust
host all gd07 localhost trust
host all gd07 127.0.0.1/32<http://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<tel:6438%203504> | www.ashnik.com<http://www.ashnik.com/;
Skype: sameer.ashnik | M: +65 8110 0350<tel:8110%200350>
[~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<http://www.ashnik.com/;
Skype: sameer.ashnik | M: +65 8110 0350
[https://www.ashnik.com/wp-content/uploads/2017/03/Final-Email-Signature.jpg]
Attachments:
[image/jpeg] image001.jpg (823B, ../7974b8ff73cc4119804e0e8c8f900a26@DC03PXMBP003.jacksonnational.com/3-image001.jpg)
download | view image
view thread (8+ messages) latest in thread
Message-ID: <7974b8ff73cc4119804e0e8c8f900a26@DC03PXMBP003.jacksonnational.com>
Permalink: ../7974b8ff73cc4119804e0e8c8f900a26@DC03PXMBP003.jacksonnational.com/
Also on: postgresql.org/message-id/7974b8ff73cc4119804e0e8c8f900a26@DC03PXMBP003.jacksonnational.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maria.rossi@jackson.com, sameer.kumar@ashnik.com, pgsql-sql@lists.postgresql.org, pgsql-novice@lists.postgresql.org
Subject: RE: md5 and trust and pg_hba.conf
In-Reply-To: <7974b8ff73cc4119804e0e8c8f900a26@DC03PXMBP003.jacksonnational.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox