Hello,
I installed PostgreSQL 7.4 with openssl option on SuSE 9.0. I created
the server.crt and server.key certificates as outlined in the online
PostgreSQL manual, and placed these certificates in the
/usr/local/pgsql/data directory. I then changed the 'ssl = false' to
'ssl = true' in postgresql.conf, and also added to pg_hba.conf:
hostssl TempDB testssluser 0.0.0.0 0.0.0.0 md5
Trying to connect from Windows using the PG ODBC 7.03.02 driver fails.
If I change my pg_hba.conf file to:
host TempDB testssluser 0.0.0.0 0.0.0.0 md5
then all works fine.
This is the first time I've used PostgreSQL, so any help/pointers would
really be appreciated.
Regards,
Sydney Delieu.