Wondering if this is applicable as I am using AWS RDS Aurora Postgres as my database. I was wondering if this is possible? AWS supports two endpoints. Cluster endpoint and Read Cluster Endpoint. Cluster endpoint is a writer/reader endpoint on for the primary/master database. While the Reade Cluster Endpoint is used for multiple Read Replicas of Postgres.
Right now, we can only specify one postgres endpoint in kong. Which means it will be hard if there will be a constant reading at some point in your plugins that requires database reading.