When connecting to a PostgreSQL database from the Syniti Knowledge Platform (SKP), provide the following connection properties to establish a secure and reliable connection. This article explains each property to understand what information is required and how it is used.
Property | Description | Notes |
|---|---|---|
Name | Name of the PostgreSQL connection unique to the SKP. | NA |
Description | Enter a description that briefly states the purpose of this connection. | NA |
Hostname | Hostname is the network name or IP address of the PostgreSQL machine you want to connect to. | * The server name, for example, PSQLPROD01. * An IP address, for example, 192.168.10.50. |
Port | The port number your PostgreSQL uses to accept connections. | By default, the PostgreSQL port is 5432. If you are not sure, you can use this default port. |
Username | The login name used to sign in to the PostgreSQL. | This login name should be an account that your administrator has created for database access. |
Password | The password for the username above. | Authenticates your connection to the database. |
Database | The name of the specific PostgreSQL database you want to connect to. | PostgreSQL can have many databases; this tells the SKP which one to use. |
Timeout | The maximum number of seconds the system will wait when trying to connect before stopping and showing an error. | Default value is 60 seconds. If your server is slow or far away, you can raise this number. |
Encoding | Specifies the character set encoding used for communication between SKP and the PostgreSQL database server. This setting ensures that textual data is correctly interpreted, stored, and retrieved, especially when working with international characters or multilingual datasets. | Default value is UTF-8 |
Pooling | Connection pooling allows the system to reuse existing database connections instead of creating a new one every time the SKP performs an operation. | * Enabled (Default): The SKP keeps a group (pool) of open database connections ready to use. This reduces the time spent opening and closing connections. * Disabled: A new connection is created and closed for each operation. This is simpler and uses fewer system resources but can be slower for frequent operations. |
Minimum Pool Size | The minimum number of connections that the system will always keep open when pooling is enabled. | Even if the SKP is idle, it will maintain at least this number of ready-to-use connections. Useful when you expect regular activity and want faster response times. For example, If Minimum Pool Size = 2, the SKP always keeps at least 2 connections open. |
Maximum Pool Size | The maximum number of connections the SKP is allowed to open when pooling is enabled. | This prevents the system or database from being overloaded with too many connections. When the pool reaches this limit, new requests must wait until a connection is released. For example, If Maximum Pool Size = 10, the SKP never opens more than 10 connections at the same time. |
SSL Mode | Mode for controlling the SSL connection. | Disable: SSL is not used. Prefer: The client first attempts an SSL connection; if that fails, it falls back to a non-SSL connection. Require: The connection must use SSL; if an SSL connection cannot be established, an error is returned. Allow: The client first attempts a non-SSL connection; if that fails, it retries using SSL. Verify-CA: SSL is required, and the server certificate must be verified against a trusted Certificate Authority (CA). Verify-Full: SSL is required, the server certificate must be verified against a trusted CA, and the server hostname must match the certificate. |
SSL Certificate Password | The password used to decrypt the SSL certificate’s private key. | NA |