How to connect RisingWave to an RDS Postgres instance when `REPLICATION` role cannot be assigned?
I'm trying to connect RisingWave to an RDS Postgres instance but encountering issues due to the lack of REPLICATION role assignment in a managed RDS setting. The RisingWave Java Connector throws an error because it requires the user to be a superuser or have the replication role. However, in RDS, I can only assign the rds_replication group, which doesn't seem to satisfy the RisingWave's validation query. Fivetran, on the other hand, works with just GRANT rds_replication TO <user>. Is there a way to bypass this validation or an alternative method to connect RisingWave to RDS Postgres?
Adam Houston
Asked on Aug 24, 2023
After discussing the issue internally, we've merged a patch to address the privilege check that didn't account for the differences between standalone and RDS Postgres. You can use our nightly image (nightly-20230825) or the main branch to get the fix. We will also update the documentation accordingly. Please try the updated version and let us know if it resolves your issue.