Skip to main content

PostgreSQL continuous real-time replication using CDC

PostgreSQL Reader uses the wal2json plugin to read PostgreSQL change data. 1.x releases of wal2jon can not read transactions larger than 1 GB. If you have transactions that large, we recommend using a 2.x release of wal2json, which does not have that limitation. When you use a 2.x release, we recommend setting the Postgres Config property to automatically use format 2 for transactions larger than 1GB and format 1 for other transactions (see PostgreSQL Reader properties).PostgreSQL Reader properties

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

If not using an automatic pipeline wizard, before creating the continuous real-time replication application, see Switching from initial load to continuous replication of PostgreSQL sources.