PostgreSQL Connection Details

Provide the information of the database server that this connection can connect to.

The PostgreSQL Connector dialog contains the following fields:
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.

  • TLS: Select the TLS mode from the list. See TLS Modes.
Note:  
  • 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.