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. Note:
Use IP address from Google Cloud SQL's PostgreSQL instance. |
Port | The port number that 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. Note: Use default port while connecting to Google Cloud SQL's PostgreSQL instance. |
Database Name | Name of the Connector database . |
User | Username 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 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 (No maximum limit exists for open connections to the database if the value is 0 or less.) |
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 |
The 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: Adjust this parameter according to the hosting environment of the database server, whether it is in the cloud or On-premises. In addition, configure the Maximum Connection Retry Attempts and the Connection Retry Delay parameters.
|
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.