Striim 4.0.4 documentation

PostgreSQL

Striim supports PostgreSQL 9.4.x and later versions, Amazon RDS for PostgreSQL, Amazon Aurora with PostgreSQL compatibility, Azure Database for PostgreSQL, Azure Database for PostgreSQL - Flexible Server, and Google Cloud SQL for PostgreSQL.

PostgreSQL Reader uses the wal2json plugin to read PostgreSQL change data. 1.x releases of wal2jon can not read transactions larger than 1 GB. We recommend using a 2.x release of wal2json, which does not have that limitation.

Striim provides templates for creating applications that read from PostgreSQL and write to various targets. See Creating an application using a template for details.