PostgreSQL

Introduction

PostgreSQL is a powerful relational database management system (RDBMS). PostgreSQL supports advanced data types, and offers extensive features for data integrity and performance optimization. Its versatility and adherence to standards make it a popular choice for managing and querying data effectively.

PostgreSQL Compatible Configurations

The following PostgreSQL database services are compatible with Data Integration:

• On-premise PostgreSQL
• Amazon RDS/Aurora PostgreSQL
• Google Cloud PostgreSQL

Compatiblity of Versions

River Modes	Versions Supported	Support for Managing Schema Drift
Standard Extraction	Versions 9.6 and Above	Yes
Change Data Capture (CDC)	Versions 9.6 and Above	Yes

Table of Contents for PostgreSQL

• Connections
  • PostgreSQL Connection
  • PostgreSQL SSL Connection
• Setup Guides
  • Amazon RDS/Aurora PostgreSQL Setup Guide
  • Google Cloud PostgreSQL Setup Guide
  • Configuring PostgreSQL CDC Replication Slots and Publications
• River Modes
  • PostgreSQL Walkthrough
  • PostgreSQL Change Data Capture (CDC) Overview
• PostgreSQL Data Type Mapping