Edit on GitHub
Repository Database in PostgreSQLlink
Fivetran HVR allows you to create a repository database in PostgreSQL.
Grants for Repository Databaselink
The following grant is required for the repository database in PostgreSQL:
- The repository User should have permission to create and drop HVR repository tables.
Repository Database Connectionlink
This section describes the details required for connecting to the repository database in PostgreSQL:
Field | Description | Equivalent Location Property |
---|---|---|
HOST | Hostname or IP-address of the server on which the PostgreSQL database is running. Example: mypostgresnode | Database_Host |
PORT | Port number on which the PostgreSQL database server is expecting connections. Example: 5432 | Database_Port |
DATABASE | Name of the PostgreSQL database. Example: mytestdb | Database_Name |
USER | Username for connecting HVR to the PostgreSQL database. Example: dbuser | Database_User |
PASSWORD | Password for the USER. | Database_Password |
Advanced Settingslink
Field | Description | Equivalent Location Property |
---|---|---|
PGLIB | Directory path of the library (lib) directory in the PostgreSQL installation. This field can be left empty to use the system default path. Example: /postgres/935/lib | PostgreSQL_Pglib |