Version: 5.4

PostgreSQL Plug-in

warning

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

Name	Any name under which this database server appears in the connection setup. Choose a name that is unique to you during the connection setup.
Host/IP/file	Address of the PostgreSQL server.
Port	Selection of the port for database connection. If necessary, the port can be changed.
Data Source	Name of the database to be used.
User	Username for logging into the PostgreSQL server.
Password	Password for logging into the PostgreSQL server.

SSL mode	Property determining how the SSL connection is managed. Here functionality is explained.
SSL certificate	Selection of an SSL client certificate from the drop-down list, which the OPC Router sends along with.
SSL password	Password to access the private key of the client certificate sent during the SSL handshake to the server.
Root certificate	Selection of a root certificate (CA) from the drop-down list, which the OPC Router sends along with.
Service name	Kerberos service name of the PostgreSQL server.
Check Certificate Revocation	Enable if the certificate revocation list should be checked during authentication. (Default is False).
Include Realm	Enable if Kerberos realm should be used for authentication.
Trust Server Certificate	Enable if the server certificate is to be trusted without validation.

Target Session Attributes	Determines the preferred PostgreSQL target server type.
Keepalive	The interval in seconds at which consecutive keepalive packets are sent when no acknowledgment is received.
Host Recheck Seconds	Specifies how long the host's cache state is considered valid.
Server Compatibility Mode	Property describing the server compatibility mode. Here functionality is explained.
Load Balance Timeout	The maximum overall lifespan of connections (in seconds). Connections exceeding this value are destroyed instead of being returned to the pool. Useful in cluster configurations to force load balancing between a running server and one that has just been brought online.
Timestamp Mode	Property defining how the timestamp is treated. Here functionality is explained.
Timezone	The timezone 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	When this option is enabled, PostgreSQL error details are included. These may contain sensitive data.
Log Parameters	When this option is enabled, parameter values are logged during command execution.

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 verifies the server certificate with the hostname.

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