Location Connection for PostgreSQL

This section describes the connection details required for creating a PostgreSQL location in Fivetran Local Data Processing. For information about the pre-requisites, access privileges, and other configuration requirements for creating Oracle location, see .

Field	Description	Equivalent Location Property
HOST	Hostname or IP-address of the server on which the PostgreSQL database is running. Example: mypostgresnode
PORT	Port number on which the PostgreSQL database server is expecting connections. Example: 5432
DATABASE	Name of the PostgreSQL database. Example: mytestdb
USER	Username for connecting Local Data Processing to the PostgreSQL database. Example: hvruser
PASSWORD	Password for the USER.

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