Version: 5.4

PostgreSQL Plug-in

warning

The PostgreSQL plug-in does not support user-defined data types or JSON as a data type.

Property	Description
Name	Any name under which this database server appears in the connection project. Choose a name that is unique to you during connection project planning.
Host/IP/File	Address of the PostgreSQL server.
Port	Selection of the port for the database connection. The port can be changed if necessary.
Data source	Name of the database to be used.
User	User name for logging on to the PostgreSQL server.
Password	Password for logging on to the PostgreSQL server.

Property	Description
SSL Mode	Property that determines how the SSL connection is managed. The functionality is explained here.
SSL Certificate	Selection of an SSL client certificate from the drop-down list, which the OPC Router sends along with the data.
SSL Password	Password to access the private key of the client certificate, which is sent to the server during the SSL handshake.
Root Certificate	Select a root certificate (CA) from the drop-down list, which the OPC Router sends along with the data.
Service Name	Kerberos service name of the PostgreSQL server.
Check certificate revocation	Enable if the certificate revocation list is to be checked during authentication. (Default is False).
Include realm	Enable if Kerboros realm is to be used for authentication.
Trust server certificate	Enable if the server certificate should be trusted without validating it.

Property	Description
Target Session Attributes	Determines the preferred PostgreSQL target server type.
Keepalive	The interval in seconds at which consecutive keepalive packets are sent if no acknowledgment is received.
Host Check Interval	Specifies how long the host's cache state is considered valid.
Server Compatibility Mode	Property that describes the server compatibility mode. The functionality is explained here.
Load Balance Timeout	The maximum total lifetime of connections (in seconds). Connections that have exceeded this value are destroyed instead of being returned to the pool. This is useful in cluster configurations to enforce load balancing between a running server and a server that has just come online.
Timestamp Mode	Property that determines how the timestamp is handled. The functionality is explained here.
Time Zone	The time zone of the PostgreSQL session in Olson/IANA database format.
Encoding	Specifies the encoding for encoding/decoding PostgreSQL string data.
Client encoding	Specifies the PostgreSQL character set used by the client.
Include error details	If this option is enabled, PostgreSQL error details are included. These may contain sensitive data.
Log parameters	If this option is enabled, parameter values are logged when commands are executed.

The SSL Mode property determines how the SSL connection is managed

Disable: SSL is disabled. If the server requires SSL, the connection will fail.
Allow: Prefers non-SSL connections if the server allows them, but also allows SSL connections
Prefer (default): Prefers SSL connections if the server allows them, but also allows connections without SSL.
Require: The connection fails if the server does not support SSL.
VerifyCA: The connection fails if the server does not support SSL. Also verifies the server certificate.
VerifyFull: The connection fails if the server does not support SSL. Also checks the server certificate with the host name.

None: No special server compatibility mode is active
NoTypeLoading: The server does not support full loading of types from the PostgreSQL catalogs.
Redshift: The server is an Amazon Redshift instance.