[ADMIN] pooler/router?
Hi all, I have a customer who needs to split a set of pg databases that have outgrown any possible big iron and needs to do it quick, at zero impact on lots of existing and basically undocumented applications. I was wondering whether there is anything I can drop in as a middleware, that will get any incoming connections to oldserver:5432 and reroute them to a set of individual boxes, based on the targeted database. PgPooler + routing, sort of. Any hint is greatly appreciated. Cheers Bèrto -- == If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] pooler/router?
Hi Bèrto, On Thu, 13 Dec 2012 12:39:28 +, Bèrto ëd Sèra berto.d.s...@gmail.com wrote: I was wondering whether there is anything I can drop in as a middleware, that will get any incoming connections to oldserver:5432 and reroute them to a set of individual boxes, based on the targeted database. PgPooler + routing, sort of. With pgbouncer you can create virtual databases and map them on different hosts. It is very light and open source: http://wiki.postgresql.org/wiki/PgBouncer Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin