Location Connection for Aurora PostgreSQL
This section describes the connection details required for creating Aurora PostgreSQL location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Aurora PostgreSQL location, see Aurora PostgreSQL Requirements.
If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.
| Field | Description | Equivalent Location Property |
|---|---|---|
| HOST | Hostname or IP-address of the server on which the Aurora PostgreSQL database is running. Example: mypostgresnode | Database_Host |
| PORT | Port number on which the Aurora PostgreSQL database server is expecting connections. Example: 5432 | Database_Port |
| DATABASE | Name of the Aurora PostgreSQL database. Example: mytestdb | Database_Name |
| USER | Username for connecting HVR to the Aurora PostgreSQL database. Example: hvruser | Database_User |
| PASSWORD | Password for the USER. | Database_Password |
Advanced Settings
| Field | Description | Equivalent Location Property |
|---|---|---|
| PGLIB | Directory path of the library (lib) directory in the Aurora PostgreSQL installation. This field can be left empty to use the system default path. Example: /postgres/935/lib | PostgreSQL_Pglib |