pg_hba.conf

From: Tom Allison <tom(at)tacocat(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_hba.conf
Date: 2006-11-20 00:08:47
Message-ID: 4560F20F.10903@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ran into a mystery that I can't seem to figure out....

I want to authenticate using SSL for all external IP addresses that I have in my
subnet. I also want to be able to authenticate via non-SSL for localhost (not
unix socket).

I thought something like this would work:

host all all 127.0.0.1/32 md5
hostssl all all 192.168.0.1/24 md5

But I have a localhost client that can't log in because it keeps trying to
authenticate via SSL.

What am I doing wrong? It seems simple enough.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Russell Smith 2006-11-20 00:16:40 Re: pg_hba.conf
Previous Message Alvaro Herrera 2006-11-20 00:04:02 Re: phpPgAdmin, cannot connect to server