PostgreSQL Requirements

This section describes the requirements, access privileges, and other features of Fivetran Local Data Processing when using PostgreSQL for replication.

For information about compatibility and supported versions of PostgreSQL with Local Data Processing platforms, see .

For the supported by Local Data Processing on PostgreSQL, see .

For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see .

For the character encodings supported by Local Data Processing on PostgreSQL, see the page.

Database Connection

Local Data Processing requires that the PostgreSQL native LIBPQ (i.e. libpq.so.5 and its dependencies) is installed on the machine from which Local Data Processing will connect to the PostgreSQL database. For information about the client versions required for connecting to the PostgreSQL server, refer to the Local Data Processing release notes (hvr.rel) available in the HVR_HOME directory or the download page.

Connecting to Amazon RDS for PostgreSQL

To enable the Local Data Processing capture or integrate process to connect to Amazon RDS for PostgreSQL, you must allow inbound traffic on the database listener port to the system running the Local Data Processing process. If a High-Volume Agent (HVA) is in place, then communication must be enabled for the system where the HVA is running. When directly connected from a Local Processing Hub Server, the connection must be allowed for the Local Processing Hub Server. If the Local Data Processing system connecting to Amazon RDS for PostgreSQL runs in the same VPC as Amazon RDS for PostgreSQL, you can use the internal rather than public IP address for the service to allow access. It is recommended to restrict access to only the Local Data Processing system that requires access, rather than allowing broader or public access.

The default database listener port that must be opened for TCP/IP connection is 5432.

NOTE: The ports may have been changed from the default by the administrator.

Related Articles