Repository Database in Aurora PostgreSQL
Fivetran HVR allows you to create a repository database in Aurora PostgreSQL. The Repository Database section in Capabilities (6.1.0, 6.1.5) lists the supported Aurora PostgreSQL versions that can be used as a repository database.
Grants for Repository Database
The following grant is required for the repository database in Aurora PostgreSQL:
- The repository User should have permission to create and drop HVR repository tables.
Repository Database Connection
This section describes the details required for connecting to the repository database in Aurora PostgreSQL:
| 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: dbuser | 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 |