PostgreSQLDatabase.SSLMode

Property (As Integer )

aPostgreSQLDatabase.SSLMode = newIntegerValue
or
IntegerValue = aPostgreSQLDatabase.SSLMode

Supported for all project types and targets.

Specifies the type of SSL connection to use to connect to the database server. Use the constant values SSLDisable, SSLAllow, SSLPrefer, SSLRequire, SSLVerifyCA and SSLVerifyFull.

Notes

These PostgreSQL constants are used to specify SSLMode:

SSLDisable (default): Only try a non-SSL connection
SSLAllow: First try a non-SSL connection; if that fails, try an SSL connection
SSLPrefer: First try an SSL connection; if that fails, try a non-SSL connection
SSLRequire: Only try an SSL connection. If a root CA file is present, verify the certificate in the same way as if verify-ca was specified
SSLVerifyCA: Only try an SSL connection, and verify that the server certificate is issued by a trusted CA
SSLVerifyFull: Only try an SSL connection, verify that the server certificate is issued by a trusted CA and that the server hostname matches that in the certificate

For more information about SSL usage with PostgreSQL, refer to Secure TCP/IP Connections with SSL.

Examples

This example specifies that the connection should try to use SSL:

Var db As New PostgreSQLDatabase
db.Host = "192.168.1.172"
db.SSLMode = PostgreSQLDatabase.SSLAllow
db.Port = 5432
db.DatabaseName = "BaseballLeague"
db.UserName = "broberts"
db.Password = "streborb"
Try
db.Connect
// Use the database
Catch error As DatabaseException
MessageBox("Connection failed. Error: " + error.Message)
End Try 