Skip to main content

PostgreSQL

PostgreSQL is an open-source relational database management system.

You can read from PostgreSQL as follows, and write to any target supported by Striim. Typically, you will set up data pipelines that read from PostgreSQL in two phases—initial load, followed by continuous replication—as explained in this concept article on Pipelines.

  • For initial load, you can use Database Reader to create a point-in-time copy of the existing source PostgreSQL dataset at the target.Database Reader

  • After initial load has completed, you can start continuous replication by continuously reading the new data created in the same PostgreSQL dataset after the initial load was started, and then writing this new source data to the target.

    • For real-time continuous replication of new source data using CDC, you can use PostgreSQL Reader.

    • If you choose not to enable CDC on the source database, you can use Incremental Batch Reader to read the new source data at regular intervals, allowing for continuous updates in near real-time.  Incremental Batch Reader differs from the CDC readers in several ways, including not capturing DELETE operations at the source (see the discussion in Incremental Batch Reader about INSERT, UPDATE, and DELETE operations)

Supported services

Striim supports reading from the following PostgreSQL database services:

  • PostgreSQL 9.4.x and later versions (self-managed; e.g., installed and managed on-premises or in a cloud VM)

  • Amazon Aurora with PostgreSQL compatibility

  • Amazon RDS for PostgreSQL

  • Azure Database for PostgreSQL

  • Azure Database for PostgreSQL - Flexible Server

  • Google AlloyDB for PostgreSQL

  • Google Cloud SQL for PostgreSQL

Striim UI wizards

You can read from PostgreSQL using the wizards on the Striim UI:

  • Automated data pipelines

  • Initial Load only

  • CDC only