Ask Your Question
2

It is possible to implement CDC in Postgres

asked 2018-01-03 11:38:51 -0500

Francisco gravatar image

I am trying to implement a pipeline to detect changing data in Postgres DB. Documentation show how to use Oracle CDC client on Oracle DB (11g or 12c) as well the Microsoft SQL Server (with JDBC origin). But i was unable to find any information about Postgres CDC. Can anyone help? Thanks.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
1

answered 2018-08-15 19:59:41 -0500

LC gravatar image

updated 2018-08-15 20:00:01 -0500

We implemented the PostgreSQL CDC Client origin in the 3.4.0 release. Check it out! https://streamsets.com/documentation/...

edit flag offensive delete link more
0

answered 2018-01-04 17:58:09 -0500

metadaddy gravatar image

Postgres CDC is not yet implemented. Please watch / comment / vote on SDC-4236.

In the meantime, you might be able to use the JDBC Query Consumer with an incremental query, if you have a unique ascending key.

edit flag offensive delete link more
0

answered 2018-01-04 03:08:44 -0500

xiaoxu gravatar image
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-03 11:38:51 -0500

Seen: 461 times

Last updated: Aug 15