On Wed, 19 Mar 2003, Tom Lane wrote:
> "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > I must say my non rpm installation doesn't seem to pick up the hostssl line in
> > pg_hba. Or at least it doesn't match it when a connection comes in. I didn't
> > get very far into looking into that so it's probably something I'm doing wrong.
>
> > FWIW, my pg_hba entry is:
> > hostssl all all xx.xx.xx.xx 255.255.255.240 md5
> > and the error I get is:
> > FATAL: No pg_hba.conf entry for host xx.xx.xx.xx, user vtc, database vtc
>
> I believe it would act that way if the incoming connection is non-SSL
> (which suggests that your libpq isn't compiled with SSL support).
Interesting you should say that because I know remember what happened, slap me
with a wet fish later for the noise.
I'm convinced I rebuilt on the workstation in order to get a libpq with ssl. I
am equally convinced I tested it and it worked. Then a couple of days later
trying to get the developers using Windows to be able to connect I looked at it
again and I found my psql was no longer linked against the ssl library. Was
very wierd.
However, I never was able to get the developers connected. I may need to
revisit that later.
Sorry for the noise, my memory is going.
--
Nigel Andrews