Re: ssl

On Wed, 19 Mar 2003, pg wrote:

> I'm using redhat 8.0 and postgresql 7.2.4 (rpm from postgresql.org). I want
> to enable ssl.
>
> I have edited postgresql.conf to ssl = true. I also follow the 7.3 manual
> (from postgresql.org) to create certificates and placed them in
> /var/lib/pgsql/data/. Then restart the server with /etc/init.d/postgresql
> restart. The result is [Failed]. What else should I do? Or procedure for 7.3
> is different from 7.2.4? Or the rpm does not have ssl enabled when compile?

How does it fail? Just with a '[Failed]' message in the logs?

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


--
Nigel J. Andrews