Skip site navigation (1) Skip section navigation (2)

ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL

From: "Sydney Delieu" <syddel(at)hotmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL
Date: 2004-04-29 09:07:12
Message-ID: c6qgjv$2m9r$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

Responses

pgsql-odbc by date

Next:From: Fred ParkinsonDate: 2004-04-29 15:22:54
Subject: Re: Any W2K issues around odbc driver install?
Previous:From: Ibrahim El-FayoumiDate: 2004-04-29 07:56:15
Subject: psqlodbc and wide characters under windows and Unix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group