Thread: [ODBC] Possible sslmode values
Hi, I'm trying to figure out what the possible values for the sslmode option for psqlODBC are. Are the options for libpq (https://www.postgresql.org/docs/9.3/static/libpq-ssl.html)the same options that may be used with psqlODBC? Best regards
On 06/26/2017 05:53 AM, Daniel H. Peger wrote: > Hi, > > I'm trying to figure out what the possible values for the sslmode option for psqlODBC are. Are the options for libpq (https://www.postgresql.org/docs/9.3/static/libpq-ssl.html)the same options that may be used with psqlODBC? From the looks of it, yes: https://odbc.postgresql.org/docs/release.html psqlODBC 08.04.0100 "16.) Add a 'verify-ca' and 'verify-full' to the sslmode option via libpq of version 8.4." The example at bottom of page: https://odbc.postgresql.org/docs/config.html shows it also. > > Best regards > > -- Adrian Klaver adrian.klaver@aklaver.com
Actually, that's why I'm asking. The release notes are the only place where the connection between the sslmode in psqlODBC and libpq is mentioned. I moreor less stumbled across this by accident because of the description of the pqopt option in the release notes. Thanks > Gesendet: Montag, 26. Juni 2017 um 15:42 Uhr > Von: "Adrian Klaver" <adrian.klaver@aklaver.com> > An: "Daniel H. Peger" <peger@gmx.net>, pgsql-odbc@postgresql.org > Betreff: Re: [ODBC] Possible sslmode values > > On 06/26/2017 05:53 AM, Daniel H. Peger wrote: > > Hi, > > > > I'm trying to figure out what the possible values for the sslmode option for psqlODBC are. Are the options for libpq(https://www.postgresql.org/docs/9.3/static/libpq-ssl.html) the same options that may be used with psqlODBC? > > From the looks of it, yes: > > https://odbc.postgresql.org/docs/release.html > > psqlODBC 08.04.0100 > > "16.) Add a 'verify-ca' and 'verify-full' to the sslmode option via > libpq of version 8.4." > > The example at bottom of page: > > https://odbc.postgresql.org/docs/config.html > > shows it also. > > > > > Best regards > > > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > > > -- > Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-odbc >
On 06/26/2017 07:32 AM, Daniel H. Peger wrote: > Actually, that's why I'm asking. > > The release notes are the only place where the connection between the sslmode in psqlODBC and libpq is mentioned. I moreor less stumbled across this by accident because of the description of the pqopt option in the release notes. psqlodbc uses libpq for this so I would say it is safe to say that it will recognize the options. The acid test is to try it. > > Thanks > -- Adrian Klaver adrian.klaver@aklaver.com