Hacker News new | past | comments | ask | show | jobs | submit
doctorpangloss | on: PgDog is funded and coming to a database near you
Is a load balancer HA?
gchamonlive | parent | next
Not by itself if it's naive, but if it's able to assess target health and avoid degraded instances then it becomes a component in HA, the other being integrating an orchestrator for gracious recovery.
doctorpangloss | root | parent
from their docs:

> PgDog does not detect primary failure and will not call pg_promote(). It is expected that the databases are managed externally by another tool, like Patroni or AWS RDS, which handle replica promotion.

nikolatt | root | parent
Why the snark comment? The PgDog project has been around for a while, it's not vibe coded.
znpy | root | parent | next
Not gp but I didn’t perceive any snark in the comment you are replying to
doctorpangloss | root | parent
okay, it does appear that the LLM didn't write any of this. i guess the simple answer is that it is not HA.
dev-ns8 | parent | next
Combined with a replication strategy and automated health checks, a load balancer could direct traffic to a healthy instance automatically.
dotancohen | parent
What happens when the load balancer fails?
inigyou | root | parent
HA has to be all the way through, in which case you might not need a load balancer because each client already connects to a separate server. If you do, then you can have one load balancer per client machine.