Data & Storage

PostgreSQL Data Ingestion

Supports logical replication slots, partitioned tables and JSONB columns, built for PostgreSQL-centric business systems.

PostgreSQL

Use cases

The business system uses PostgreSQL as its primary database and needs data reliably consolidated into the metrics layer, or queried during a process to drive rule decisions.

Capabilities

  • Incremental capture based on logical replication (wal2json / pgoutput)
  • Partitioned table support, schema change detection and JSONB field expansion
  • Connection-level SSL and read-replica-preferred routing options
  • Built-in connection and replication slot monitoring with automatic alerts

Prerequisites

Logical replication must be enabled and an account with REPLICATION privileges created. For managed cloud databases, verify that the version in use supports logical replication slots.