hailin0 commented on issue #6407:
URL: https://github.com/apache/seatunnel/issues/6407#issuecomment-2164956101

   Please check your database settings
   
https://github.com/apache/seatunnel/blob/dev/docs/en/connector-v2/source/Postgre-CDC.md#using-dependency
   
   
   
   
   Here are the steps to enable CDC (Change Data Capture) in PostgreSQL:
   
   Ensure the wal_level is set to logical: Modify the postgresql.conf 
configuration file by adding "wal_level = logical", restart the PostgreSQL 
server for the changes to take effect. Alternatively, you can use SQL commands 
to modify the configuration directly:
   ```sql
   ALTER SYSTEM SET wal_level TO 'logical';
   SELECT pg_reload_conf();
   
   -- Change the REPLICA policy of the specified table to FULL
   ALTER TABLE your_table_name REPLICA IDENTITY FULL;
   ```


-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to