PostgreSQL Requirements - DSS 6 | Data Source Solutions Documentation
Documentation: PostgreSQL Requirements - DSS 6 | Data Source Solutions Documentation
PostgreSQL Requirements
This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using PostgreSQL for replication.
Supported Services
DSS supports the following PostgreSQL database services:
-
Generic PostgreSQL (including Amazon RDS for PostgreSQL and other hosted versions).
-
YugabyteDB
<b>Since:</b> 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 DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
-
Discover what DSS 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 DSS 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 DSS supports for PostgreSQL on the Supported Character Encodings page.
Data Source Solutions provides additional solutions for replicating data from PostgreSQL. For more information, see section PostgreSQL in Databases.
Database Connection
DSS requires the PostgreSQL native client library "libpq" (i.e. libpq.so.5 and its dependencies) to be installed on the machine from which DSS connects to the PostgreSQL server.
Connecting to Amazon RDS for PostgreSQL, Aurora PostgreSQL and YugabyteDB
To enable the DSS 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 DSS process.
If an DSS Agent is in place, then communication must be enabled for the system hosting the DSS Agent. When connecting directly from an DSS Hub Server, the connection must be allowed for the DSS Hub Server.
For the DSS 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 DSS 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.