Hi Bèrto,
On Thu, 13 Dec 2012 12:39:28 +0000, Bèrto ëd Sèra
<berto.d.sera@xxxxxxxxx> 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.Bartolini@xxxxxxxxxxxxxx - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin