dockerzhang commented on code in PR #637: URL: https://github.com/apache/inlong-website/pull/637#discussion_r1043027819
########## docs/data_node/extract_node/postgresql-cdc.md: ########## @@ -69,6 +69,28 @@ shared_preload_libraries = 'decoderbufs' wal_level = logical ``` +### replica identity + +`REPLICA IDENTITY` is a PostgreSQL-specific table-level setting that determines the amount of information that is available to the logical decoding plug-in for UPDATE and DELETE events. See [more](https://debezium.io/documentation/reference/stable/connectors/postgresql.html#postgresql-replica-identity). + +Please keep the `replica indentity` level of source tables to `FULL`. You can check and change this value by SQL: + +```aidl +-- show replica identity +SELECT CASE relreplident + WHEN 'd' THEN 'default' + WHEN 'n' THEN 'nothing' + WHEN 'f' THEN 'full' + WHEN 'i' THEN 'index' + END AS replica_identity +FROM pg_class +WHERE oid = 'mytablename'::regclass; + +-- change replica identity +ALTER TABLE mytablename REPLICA IDENTITY FULL; +``` + Review Comment: remove the extra line -- 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: commits-unsubscr...@inlong.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
