Oh, my problem is My server doesn't even start, and there's no log about
this start failure. Screen dump as below :
============
[root@local init.d]# ./postgresql start
Starting postgresql service: [ FAILED ]
============
Does the postgresql contained in standard (from postgresql.org) compiled
with ssl enabled?
-Jason
----- Original Message -----
From: "Nigel J. Andrews" <nandrews@investsystems.co.uk>
To: "pg" <pg@newhonest.com>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, March 19, 2003 4:51 PM
Subject: Re: [GENERAL] 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
>