search

yandex / odyssey

Scalable PostgreSQL connection pooler
BSD 3-Clause "New" or "Revised" License
3.2k stars 161 forks source link

Patroni / backend healthcheck #418

Open mr-deamon opened 2 years ago

mr-deamon commented 2 years ago

Hi there I am building a new active-hotstandby database-setup with patroni. I intended to use pgbouncer (as the old setup had), but just now learned about this project. The big advantage of odyssey would be the way simpler implementation of ldap-auth.

Because i am working with patroni i relay on haproxy with routes the traffic to the current r/w host, it is doing so by watching patronis health-api.

My question: Is odyssey somehow able to handle two pg-servers in one backend and automatically route traffic to the current active node? If so, how? I did not see how this could be done in the docs... This would be a killer feature for us and we would switch from pgbouncer pretty soon i think :)

RedCreepster commented 1 year ago

It's not possible without haproxy.