Patroni / backend healthcheck

[mr-deamon]

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]

It's not possible without haproxy.