liaorui opened a new pull request, #6736: URL: https://github.com/apache/inlong/pull/6736
### Prepare a Pull Request *(Change the title refer to the following example)* - Title Example: [INLONG-XYZ][Component] Title of the pull request *(The following *XYZ* should be replaced by the actual [GitHub Issue](https://github.com/apache/inlong/issues) number)* - Fixes #6735 ### Motivation *Explain here the context, and why you're making that change. What is the problem you're trying to solve?* Inspired by mysql-cdc-inlong, postgres-cdc-inlong can also support transferring all tables in one database on time by debezium's ability. Based on debezium-connector-postgres, postgres-cdc-inlong can assemble two data formats, which are canal-json and debezium-json. Postgres Logical decoding does not support DDL changes, this means that the debezium connector is unable to report DDL change events back to consumers. But postgres-cdc-inlong can do this, using JDBC query for table schema when data field changes in debezium data streams. Postgres-cdc-inlong also supports metrics for data transferring. ### Modifications *Describe the modifications you've done.* 1. PostgresSQLSource class has two new parameters, serverTimeZone and scanStartupMode. The former is Postgres Server time zone such as Aisa/Shanghai etc. The later is passed to debezium.scan.mode, the value is initial or never. 2. PostgresExtractNode also has serverTimeZone and scanStartupMode. It overwrites the getMetadataKey method to support canal-json and debezium-json meta field. 3. DebeziumChangeFetcher overwrites getTableChange method by using JDBC query for table, as debezium-connector-postgres cannot capture table changes. 4. RowDataDebeziumDeserializeSchema provides the parsers for reading tables. 5. PostgreSQLReadableMetaData provides the parsers for canal-json, debezium-json and op_type meta fields. 6. The classes in connection and manager packages are the JDBC tools to query postgres table meta info. ### Verifying this change *(Please pick either of the following options)* - [ ] This change is a trivial rework/code cleanup without any test coverage. - [ ] This change is already covered by existing tests, such as: *(please describe tests)* - [ ] This change added tests and can be verified as follows: *(example:)* - *Added integration tests for end-to-end deployment with large payloads (10MB)* - *Extended integration test for recovery after broker failure* ### Documentation - Does this pull request introduce a new feature? (yes / no) - If yes, how is the feature documented? (not applicable / docs / JavaDocs / not documented) - If a feature is not applicable for documentation, explain why? - If a feature is not documented yet in this PR, please create a follow-up issue for adding the documentation -- 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
