Search Postgresql Archives

Re: Status of SSL encryption in ODBC driver

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



sslmode=require did the trick.  Thanks!

Dave Page wrote:

John McCawley wrote:

Where would I go to find the connection string settings to turn it on? I have dug around quite a bit, and tried everything I have found, but nothing seems to work, and the docs included with the driver don't seem to cover it.


The easy method is to setup a DSN as required, then connect it with logging enable using any old ODBC app and pull the connection string from the logfile.

IIRC though, you need one of:

sslmode=disable
sslmode=allow
sslmode=prefer
sslmode=require

If you use the first, libpq will not be loaded which means that the other benefits of it (the kerberos support, pgpass.txt etc) will also not be available. The reason it is done this way is to allow the driver to be distributed as a single DLL for those that require the most basic setup. In all other cases, libpq (and it's myriad of supporting DLLs) will be dynamically loaded and used for connection setup.

Regards, Dave.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux