this is awesome but I'm wondering does pgdog plan to handle high availability scenarios (multiple frontend proxies)? I know this can lead to much more difficult problems with consensus and handling split brain scenarios.
if not, what is the approach to enable restarts without downtime? (let's say one node crashes)?
It's config driven, so no split brain. All proxies have the same config and deployments are synchronized:
1. pause traffic 2. reload config 3. resume traffic
This can be done in under a second.
Restarts without downtime can be handled with blue/green using and a TCP load balancer or DNS.