[GitHub] [nifi] davyam edited a comment on pull request #4065: NIFI-4239 - Adding CaptureChangePostgreSQL processor to capture data changes (INSERT/UPDATE/DELETE) in PostgreSQL tables via Logical Replication.

[GitBox <gi...@apache.org>]

davyam edited a comment on pull request #4065:
URL: https://github.com/apache/nifi/pull/4065#issuecomment-671332330


   > @davyam Do you know that this CDC solution for PostgreSQL supports DDL events like in CaptureChangeMySQL, there is a boolean property `Include DDL Events`? But in the `nar` file that @gerdansantos shared with us this field is absent.
   
   Hi @energy2522, sorry for the delay.
   So, the short answer is no, it does not support. This CDC solution uses the native PostgreSQL logical replication API, that only replicates data changes.
   If you need the initial state of subscribed tables (to make a CREATE TABLE and INSERT for existing rows) you can use the SNAPSHOT property.
   The CaptureChangePostgreSQL is based on pgEasyReplication, then you can find more info here [https://github.com/davyam/pgEasyReplication](url)


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org