<--- Back to all connectors

PostgreSQL

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. Streamkap can connect to PostgreSQL by connecting to a replication slot, which in turn looks at PostgreSQL publications. By reading the PostgreSQL change logs, real-time change data capture has less impact on your database while allowing you to sync your data in real-time to support your use cases.

The PostgreSQL Destination connector supports idempotent write operations by using upsert semantics and basic schema evolution

The PostgreSQL Destination connector supports idempotent write operations by using upsert semantics and basic schema evolution.

The following features are supported:

  • Consuming complex Debezium change events
  • At-least-once delivery
  • Multiple tasks
  • Data and column type mappings
  • Primary key handling
  • Delete mode
  • Idempotent writes
  • Schema evolution
  • Quoting and case sensitivity

Marcin Migda

Staff Data Engineer

"Streamkap was 4x faster and had 3x lower total cost of ownership than our previous solution"

Why Streamkap?

Reliable

Serverless platform providing enterprise reliability and scale.

Affordable

Only pay for GB into Streamkap.

Longterm

Retain data for as long as you need.

Flexible

Read once, write to many destinations.