RE: md5 and trust and pg_hba.conf

From: David Raymond <David(dot)Raymond(at)tomtom(dot)com>
To: "'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 20:39:55
Message-ID: VI1PR07MB0784E0119ECF7B23FCAACE7E87050@VI1PR07MB0784.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

Not a problem. You're always free to remove or obscure private info when posting to a public list, especially things like IP addresses. We just recommend leaving a note of that in case "something else here" is actually important.

So you could say:

Here's pg_hba.conf (names have been changed to protect the innocent):

#stuff here for specific other databases I'm not trying to connect to
host all all ip-of-the-server/32 md5
host all user1 ip-of-the-server/32 trust
host all user1 all md5
host all user2 ip-of-the-server/32 trust
host all user2 all md5

Then if we think the problem is in the redacted section we can suggest what to look for in there.

From: Rossi, Maria [mailto:maria(dot)rossi(at)jackson(dot)com]
Sent: Monday, September 10, 2018 3:47 PM
To: 'Sameer Kumar'
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

Hi,

I think, I  got it .   Thanks for pointing me to the right direction.
...
Sorry for hesitating to post the entire pg_hba.conf.   

Thanks again.

Maria

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jain, Abhishek 2018-09-11 13:53:37 OracleBulkCopy in PostGreSQL
Previous Message Rossi, Maria 2018-09-10 19:47:04 RE: md5 and trust and pg_hba.conf

Browse pgsql-sql by date

  From Date Subject
Next Message Voillequin, Jean-Marc 2018-09-14 09:22:31 create policy/using expression
Previous Message Rossi, Maria 2018-09-10 19:47:04 RE: md5 and trust and pg_hba.conf