Tried doc search, pgsql-general and #postgresql.
Server: 7.4.8 on Red Hat EL4. Client psql 8.0.3 on WinXP.
Using a test server.crt and server.key, as described in 8.0 docs 16.8, I
can activate SSL encryption (WinXP 8.0.3 psql reports SSL Connection at
connect), and as expected, the server log
Server: 7.4.8 on Red Hat EL4. Client psql 8.0.3 on WinXP. Using a
test server.crt and server.key, as described in 8.0 docs 16.8, I can
activate SSL encryption (WinXP 8.0.3 psql reports SSL Connection
at connect), and as expected, the server log reports that root.crt
is not found. If I copy
To the last sentence in my last post Re: SSL client crt verification:
From docs I understand that I only have to set SSL = true in postgresql.conf
to switch it on (in addition to providing the crt and key files).
I should have added:
...and using hostssl in pg_hba.conf (although host also works
Installing postgresql 8.2.0 on Windows XP Pro SP2 using the msi installer dated
2006-12-04, with libeay32.dll and ssleay32.dll (both dated 2005-07-06) (and
libiconv-2.dll, libintl-2.dll, and libpq.dll) from a previous installation (of
version 8.0.5) already present in c:\windows\system32. These
I uninstalled postgresql, removed the 5 files mentioned above from
system32. When I installed 8.2.0 again, the installer reported that
The installer has detected an incompatible version of OpenSSL
installed in your system PATH. PostgreSQL requires OpenSSL 0.9.7 or
later. If you remove your
Using libpq with pg 8.2.1 on WinXP Pro SP2.
After a PQExec with a fetch from a scroll cursor, I only get FETCH from
PQcmdStatus, and not FETCH count as described in the 8.2.1 docs. However,
PQntuples returns the number of fetched rows. If I replace the FETCH by a
MOVE, PQcmdStatus returns MOVE
