all-things-risingwave
How can I use postgres_fdw to connect RisingWave and what are the challenges faced?
I want to connect my primary postgres to RisingWave using postgres_fdw, but encountering errors related to ISOLATION LEVEL. What are the steps to use postgres_fdw for this purpose and what challenges may arise?
Mi
Ming Fang
Asked on Jan 03, 2024
- To use postgres_fdw to connect RisingWave, you can follow these steps:
- Create a foreign server for RisingWave
- Import the foreign schema from RisingWave
- Query the tables from RisingWave in your primary postgres
- Challenges faced when using postgres_fdw to connect RisingWave:
- Errors related to unsupported features like ISOLATION LEVEL
- Potential performance issues due to internal cursor usage in postgres_fdw
- Need for additional testing and support from RisingWave for compatibility
- Consideration of alternative solutions like using sinks or materialized views for data integration
Jan 03, 2024Edited by