"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).
regards, tom lane