jk-shah opened a new issue, #39959: URL: https://github.com/apache/beam/issues/39959
### What would you like to happen? **Feature**: Support a native PostgreSQL I/O with streaming support. **Expectation**: Create a a dedicated, high-performance PostgreSQL connector with native PostgreSQL streaming and write sinks that works with databases that are either self-hosted or managed. **Requirements**: Main functionality will be to deliver the initial snapshot and stream continuity. It should be able to support native PostgreSQL binary protocol and handle transactional and non-transactional logical messages. Ability to support two-phase commit transactions. It must be able to handle TOAST columns in Beam runner-managed state without issuing point queries to the live database. Handling DDL changes in logical replication is hard but should be able to handle DDL changes or have guardrails around it. Finally it needs to do it at scale even for write sink to PostgreSQL. ### Issue Priority Priority: 2 (default / most feature requests should be filed as P2) ### Issue Components - [ ] Component: Python SDK - [ ] Component: Java SDK - [ ] Component: Go SDK - [ ] Component: Typescript SDK - [x] Component: IO connector - [ ] Component: Beam YAML - [ ] Component: Beam examples - [ ] Component: Beam playground - [ ] Component: Beam katas - [ ] Component: Website - [ ] Component: Infrastructure - [ ] Component: Spark Runner - [ ] Component: Flink Runner - [ ] Component: Prism Runner - [ ] Component: Twister2 Runner - [ ] Component: Hazelcast Jet Runner - [ ] Component: Google Cloud Dataflow Runner -- 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]
