If you are using SAS/ACCESS^® Interface to PostgreSQL and the driver that shipped with your SAS software, you might receive an error when you try to enable SSL. The errors shown below occur if your PostgreSQL database requires a Secure Sockets Layer (SSL) connection:

The problem occurs because the driver that is currently shipped with the SAS software does not support SSL.

Workaround

1. Contact SAS Technical Support for the latest available SSL enabled driver. Then, upgrade your current driver.
2. Once you have downloaded and installed the new drivers, use either a LIBNAME or ODBC DSN option to specify which SSL mode to use.
    
   • To specify the SSLMODE parameter in a LIBNAME option, use the CONOPTS= option:
     libname mypost postgres server="server-name" port=5432 database=db-name
     user=user-ID password=password schema=schema conopts="sslmode=require";
   • Or, to specify in an ODBC DSN file, add SSLmode=require under the ODBC DSN entry that you want to be SSL enabled.

This link, SSL Support, provides more information about PostgreSQL SSL and values that can be used with the SSLMODE parameter. Consult your PostgreSQL database administrator about which value you should enter if SSL is enabled.

Operating System and Release Information