Hi There, we have a couple of databases running in a single region using a shared pooler, and with the maintenance downtime coming up, what is the best / lightest way to mitigate that? do we need to switch to a dedicated pooler if we want to maintain full DB access? if we are only concerned about read access, i'm assuming that a read replica in a different region would solve that?
would love if anyone can confirm the above or let me know also are there other ways?
SteveP is seeking advice on mitigating downtime during upcoming pooler maintenance. They are considering switching to a dedicated pooler or using a read replica for read access. Garyaustin suggests using the built-in pgbouncer pooler for Pro users.
This was a dev's early response on the projected impact... hopefully none... https://discord.com/channels/839993398554656828/1506644059182207127/1506745221570891786
If you are Pro I believe the recommended approach is the built in pgbouncer pooler over the "community" poolers.