“Can you check /var/log/messages and see if there’s messages every 30 minutes about ENA going down and then back up?”
Isn't this "sysadmin 101" ?
Like... the first thing to check on any server exhibiting weird behaviour ? :-)
A message about a NIC going up & down every 30min would have triggered many here instantly.
This project makes is super easy to setup a resilient and highly-available postgresql cluster.
And since the postgresql client lib handle connection to multiple replica... no need for some kind of load-balancer (pg_bouncer, pgpool...) in front of it anymore (even if they can still be useful sometimes).
pgbouncer is not a load balancer, it's a connection pooler.
The former is used to split reads and writes (and so far I haven't seen "magic" tools that automate it well, pgpool has lots of issues; this task is better to solve in app code -- most modern frameworks either already solved it such as RoR, or at least work well with 2 connections),
the latter is used to multiplex connections and improve performance similarly to nginx, haproxy, envoy, but with native Postgres protocol support.