Amazon Aurora PostgreSQL
Amazon Aurora PostgreSQL is a fully managed relational database service compatible with PostgreSQL, offering high performance, scalability, and availability. It combines the familiarity and features of PostgreSQL with the speed and resilience of cloud-native architecture.
Prerequisites
The following prerequisites must be met for a user to create and test a successful connection.
- Amazon Aurora PostgreSQL server must be accessible from the iceDQ server.
- Valid credentials to access the database.
- Amazon Aurora PostgreSQL JDBC version 15.0 or above.
Authentication Mechanism
The following authentication mechanism is supported.
- Username and Password
Connection Properties
Use the properties create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Aurora_Prod_conn |
| Driver * | Driver used to establish the connection. One driver is available by default. | Amazon Aurora PostgreSQL Native JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format supported by the driver: jdbc:postgresql://[host]:[port]/[database] | jdbc:postgresql://aurora-cluster.cluster-582045208563.us-east-1.rds.amazonaws.com:5432/my_database |
| Host * | The endpoint (hostname) of the Amazon Aurora MySQL cluster or instance. | aurora-cluster.cluster-582045208563.us-east-1.rds.amazonaws.com |
| Port * | Port on which the Aurora PostgreSQL server listens. The default is 5432. | 5432 |
| Database * | Name of the target database in Aurora PostgreSQL. | my_database |
| Type * | The connection type – either System Connection or User Connection. Refer to Connections for more details. | System or User |
| Username * | Database login username with necessary privileges. | john_doe |
| Password * | Password associated with the specified username. | aurora_password |
Custom Properties
Custom properties are optional connection parameters in the Amazon Aurora PostgreSQL driver, allowing customization of settings like timeouts and proxy configurations. A list of supported properties is available here. The availability and behavior of custom connection properties may vary depending on the version of the Amazon Aurora PostgreSQL JDBC driver in use.
Supported Datatypes
The following data types are supported:
- DATE
- TIME
- DATETIME
- TIMESTAMP
- TINYINT
- SMALLINT
- MEDIUMINT
- INT
- BIGINT
- FLOAT
- DECIMAL
- DOUBLE
- CHAR
- VARCHAR
- TEXT
- TINYTEXT
- MEDIUMTEXT
- LONGTEXT
- BIT
- BINARY
Unsupported Datatypes
The following datatypes are not supported:
- SPATIAL
- BLOB
- TINYBLOB
- MEDIUMBLOB
- GEOMETRIC
- JSON
- COMPLEX