<div dir="ltr"><div><div><div><div><div><div><div><div>Hoi,<br><br></div>We have a setup where due to differing replication requirements we have some databases in cluster A and some in cluster B. We're also looking at connection pooling because there a lot of clients that aren't going to do doing very many queries.<br>
<br></div>Looking through the documentation it doesn't seem like pgpool2 handles this in a single process, so I have it going with two separate pgpool instances. However, I was wondering if it wouldn't be an idea to allow users to specify database names in the configuration and route to the backend that contains that database.<br>
<br></div>What I'm think of is an option like:<br><br></div>backend_dbnames0=foo,bar_*<br></div>backend_dbnames1=baz<br><br></div>So if a connection comes in for database foo_2, it will be sent to backend0 but not backend1.<br>
<br></div>Does this sound like something people would be interested it, or is it too niche?<br><br></div>Have a nice day,<br><div><div><div><div><div><div><div><div><div><div>-- <br>Martijn van Oosterhout <<a href="mailto:kleptog@gmail.com">kleptog@gmail.com</a>> <a href="http://svana.org/kleptog/">http://svana.org/kleptog/</a>
</div></div></div></div></div></div></div></div></div></div></div>