PostgreSQL Requirementslink
This section describes the requirements, access privileges, and other features of Fivetran HVR when using PostgreSQL for replication.
HVR supports the following PostgreSQL database services:
- Generic PostgreSQL (including Amazon RDS for PostgreSQL and other hosted versions of PostgreSQL).
- Amazon Aurora PostgreSQL
For more information, see our Hosted Database Support Policy.
For information about compatibility and supported versions of PostgreSQL with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on PostgreSQL, see Capabilities for PostgreSQL.
For the Capabilities supported by HVR on Aurora PostgreSQL, see Capabilities for Aurora PostgreSQL.
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 Data Type Mapping.
For the character encodings supported by HVR on PostgreSQL, see the Character Encodings page.
Fivetran provides additional solutions for replicating data from PostgreSQL. For more information, see section PostgreSQL in Databases.
Database Connectionlink
HVR requires the PostgreSQL native client library "libpq" (i.e. libpq.so.5 and its dependencies) to be installed on the machine from which HVR connects to the PostgreSQL server.
Connecting to Amazon RDS for PostgreSQL and Aurora PostgreSQLlink
To enable the HVR capture or integrate process to connect to Amazon RDS for PostgreSQL or Aurora PostgreSQL, you must allow inbound traffic on the database listener port to the system running the HVR process.
If an HVR Agent is in place, then communication must be enabled for the system hosting the HVR Agent. When connecting directly from an HVR Hub Server, the connection must be allowed for the HVR Hub Server.
For the HVR system operating within the same Virtual Private Cloud (VPC) as Amazon RDS for PostgreSQL or Aurora PostgreSQL, you can use the internal rather than public IP address for the service to allow access. It is recommended to restrict access strictly to the HVR system that requires it, rather than allowing broader or public access.
The default TCP port that PostgreSQL listens on is 5432.