[Pgpool-general] Connecting more then one backend

[Ow Mun Heng]

On Thu, 2008-04-17 at 16:27 -0500, Boardley, Robert W wrote:
> >On Wed, 2008-04-16 at 10:12 -0500, Boardley, Robert W wrote:
> >> I apologize I may have not stated my question correctly. I am in need
> >> of a way to create an access server that users log into and that can
> >> access multiple independent PostgreSQL servers. I was under the
> belief
> >> that PGPOOL would fulfill this role. If PGPOOL will fulfill this role
> >> then how do I configure it in order to accomplish this need?
> 
> >Pgpool can be configured as a load balancer. Is this what you're
> >referring to?
> 
> 
> Sort of, we are trying to create multiple connection pools for multiple
> independant, unrelated database servers. We want our users to be able to
> access any of our database servers from a single connection point or in
> the future a small group of servers that can act as connection point.
> 
> Background: Currently there are only 6 postgresql servers on our
> platform (a pilot program for OSS DB), but this will hopefull become a
> viable alternative to our 400 ish DB2, Informix, MS SQL, Tandem, Oracle
> database servers.
> 

I'm not sure if pgpool can handle what you want because based on your
requirements, it's not exactly load balancing whch you want but more
like a virtual IP/port combo to connect to which in turn connects to the
rest of the boxes. But as you mentioned, these backend boxes are
independent of each other, so you gotta have some level of code to do
the mapping at the front-end. If there isn't such a thing being coded,
then I don't think pgpool can do what you want.

I may be mistaken though.