PostgreSQL Connection Details
Provide the information of the database server that this connection can connect to.
| Field | Description |
|---|---|
| Database Type |
Type of the database. You can select PostgreSQL, Redshift, or Greenplum from the drop-down options. Default: PostgreSQL |
| 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 Connector database |
| Port | The port number which the connector database is configured to listen on. Note: By default, the PostgreSQL and Greenplum Connector clusters are configured with port 5432 and the Redshift Connector cluster with port 5439. For custom configurations, see the respective product documents.
|
| Database Name | Name of the Connector database |
| User | User name of the Connector database user |
| Password | Password for the Connector database account |
| Maximum Open Connections | Sets the maximum number of open connections to the database.
If the number of Maximum Idle Connections are greater than 0 and the Maximum Open Connections are less than the Maximum Idle Connections, then the Maximum Idle Connections are 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 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.