You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I mean is this not the natural thing to do to replace bgbouncer / pgpool and all the other tools?
Nice side effect: haproxy happens to be the lb of choice of many orchestration frameworks under the hood, like rancher and I believe docker swarm and kubernetes also work atop of haproxy or can be configured that way...
Not sure if this is insane or just nobody has asked this question, so far...
@blaggacao do I understand correctly that you want to parse sql statements and route them to the primary or replica, depending on what kind of statement you've got?
Activity
blaggacao commentedon Jan 26, 2018
Someone has already played arround with postgres and lua: https://github.com/norman/lua-postgres
blaggacao commentedon Jan 26, 2018
postgres marries haproxy -> haprosql 😄
blaggacao commentedon Jan 26, 2018
/cc @CyberDem0n @alexeyklyukin @feikesteenbergen
blaggacao commentedon Jan 30, 2018
@jirutka, You might be probably the expert on this having contributed repmgr package to alpine linux and having some lua repos on your github...
CyberDem0n commentedon Jan 30, 2018
@blaggacao do I understand correctly that you want to parse sql statements and route them to the primary or replica, depending on what kind of statement you've got?
blaggacao commentedon Jan 30, 2018
@CyberDem0n That's been more or less the idea... 😄
Additionally to something that does connection pooling directly on a haproxy...
blaggacao commentedon Jan 30, 2018
... once there, failover would only be a stone's throw away.