IPrimaryPostgresSPLD.SSLMode

Syntax

SSLMode: PostgresSSLMode;

Description

The SSLMode property determines a mode of SSL connection work.

Comments

The property is relevant only on setting up parameters of database security module. The PostgresSSLMode.Prefer connection mode is used by default.

Example

Executing the example requires that the repository contains a database with the DB_POSTGRESQL identifier. The database is set up for connection to a PostgreSQL based server.

Add links to the Db and Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    DB: IDatabase;
    LogonData: IPrimaryPostgresSPLD;
Begin
    MB := MetabaseClass.Active;
    DB := MB.ItemById("DB_POSTGRESQL").Edit As IDatabase;
    // Security module settings
    LogonData := DB.LogonData As IPrimaryPostgresSPLD;
    LogonData.SSLMode := PostgresSSLMode.VerifyFull;
    (DB As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, connection mode using SSL connection is changed in database settings

See also:

IPrimaryPostgresSPLD