Amazon Aurora for PostgreSQL connection
Amazon Aurora for PostgreSQL is a relational database service compatible with PostgreSQL.
Create a connection to Amazon Aurora for PostgreSQL
To create the connection asset, you need these connection details:
- Database name
- Hostname or IP address
- Port number
- Login timeout: Set the login timeout in seconds. If this is not specified, the default value of 30 to 60 seconds will be used.
- Use Proxy server (optional)
Select Use Proxy server to access the data source through a server proxy. Depending on its setup, a server proxy can provide load balancing, increased security, and privacy. The server proxy settings are independent of the authentication credentials and the personal or shared credentials selection. The server proxy settings cannot be stored in a vault.
- Proxy hostname or IP address: The proxy URL. For example, https://proxy.example.com.
- Server proxy port: The port number to connect to the proxy server. For example, 8080 or 8443.
- The Proxy username and Proxy password fields are optional.
Credentials
- Username and password
Certificates
- Port is SSL-enabled: Enable this option if the port you have chosen is configured to accept SSL connections.
If the Port is SSL-enabled option is enabled, fill in the following fields:
- SSL certificate: Enter the SSL certificate of the host to be trusted
- Hostname in SSL certificate: The hostname in SubjectAlternativeName or Common Name (CN) part of the SSL certificate
- Validate the SSL certificate: Enable this option to validate that the SSL certificate returned by the host is trusted.
Additional properties
- Query timeout: Set the query timeout, in seconds, for for all statement created by a connection. The default value is 300 seconds.
- Retry limit: Specify the maximum number of retry connection attempts to be made by a connector, with an increasing delay between each retry attempt. The default value is two attempts.