Re: ssl

How is one supposed to connect to the SSL connection from script languages?

Nigel J. Andrews wrote:
> 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
>
>