PostgreSQL Connection Details
Provide the information of the PostgreSQL server that this connection can connect to.
| Field | Description |
|---|---|
| Connection Name | A name for the PostgreSQL connection that you are creating |
| Description | A short string describing the connection |
| Host | URL of the server that hosts the PostgreSQL database |
| Port | Port number on which the PostgreSQL Connector database listens
Note: By default, the PostgreSQL Connector cluster is configured with port 5432. For custom configurations, the valid port range is 1024 - 32767.
|
| Database Name | Name of the PostgreSQL database |
| User | User name of the PostgreSQL database user |
| Password | Password for the PostgreSQL database account |
| Maximum Open Connections | Sets the maximum number of open connections to the database.
If Maximum Idle Connections is greater than 0 and the Maximum Open Connections is less than the Maximum Idle Connections, then the Maximum Idle Connections is reduced to match the Maximum Open Connections value. Default: 0 (If the value is less than or equal to 0, then there is no maximum limit to the number of open connections to the database.) |
| Maximum Idle Connections | Sets the maximum number of connections in the idle connection pool.
If Maximum Open Connections is greater than 0 but less than the Maximum Idle Connections, then the Maximum Idle Connections is reduced to match the Maximum Open Connections value. Default: 2 If the value is less than or equal to 0, then no idle connections are retained. |
| Maximum Connection Lifetime | Sets the maximum amount of time for which a connection can be reused.
Expired connections are closed before reuse. Default: 0 (If the value is less than or equal to 0, then the connection can be used forever.) Valid time units: ns, us (or µs), ms, s, m, h. Example: 60s, 60m, 6h45m. |
| Maximum Connection Retry Attempts |
Maximum number of attempts the PostgreSQL connector tries to connect to a database server in case of connection failure. Default: 3 |
| Connection Retry Delay |
The time interval between the connection retry attempts. Default: 5 seconds |
| Connection Timeout |
Wait time for establishing the connection. Default: 20 seconds Note: This parameter needs to be tuned based on where the database server is hosted (cloud or on-premise) along with the other connection parameters like Maximum Connection Retry Attempts and the Connection Retry Delay.
|
| Secure Connection |
Establishes the secure connection when set to True.
|
- Maximum Open Connections must be less than the limit on the number of connections imposed by your database and infrastructure.
- Higher Maximum Open Connections and Maximum Idle Connections values can lead to better performance. However, having a large idle connection pool (with connections that are not reused) can lead to reduced performance.
- To mitigate the risk mentioned in the preceding point, set a relatively short Maximum Connection Lifetime. However, it must not be so short that leads to connections being ended and re-created unnecessarily often.