PostgreSQL Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using PostgreSQL for replication.
Supported Services
HVR supports the following PostgreSQL database services:
Generic PostgreSQL (including Amazon RDS for PostgreSQL and other hosted versions).
YugabyteDB
Since: v6.2.5/0
For more information about our support for hosted databases, see the Hosted Database Support Policy page.
Supported Platforms
- Learn about the PostgreSQL versions compatible with HVR on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
Discover what HVR offers for PostgreSQL on our Capabilities for PostgreSQL page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
For Aurora PostgreSQL-specific capabilities, check out the Capabilities for Aurora PostgreSQL page (6.1.0, 6.1.5).
Data Management
Learn how HVR maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of supported PostgreSQL data types and their mapping, see Data Type Mapping for PostgreSQL.
Understand the character encodings HVR supports for PostgreSQL on the Supported Character Encodings page.
Fivetran provides additional solutions for replicating data from PostgreSQL. For more information, see section PostgreSQL in Databases.
Database Connection
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, Aurora PostgreSQL and YugabyteDB
To enable the HVR capture or integrate process to connect to Amazon RDS for PostgreSQL, Aurora PostgreSQL, or YugabyteDB, 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, Aurora PostgreSQL, or YugabyteDB, 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 Amazon RDS for PostgreSQL and Aurora PostgreSQL is 5432. The default TCP port that YugabyteDB listens on is 5433.