Location Connection for PostgreSQL
This section describes the connection details required for creating a PostgreSQL location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Oracle location, see 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 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: 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 PostgreSQL installation. This field can be left empty to use the system default path. Example: /postgres/935/lib | PostgreSQL_Pglib |