| From: | Gabriele Bartolini <Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it> |
|---|---|
| To: | Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pooler/router? |
| Date: | 2012-12-13 13:07:26 |
| Message-ID: | bba38b39b422e6eebe883bbf3a400b84@2ndquadrant.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Bèrto,
On Thu, 13 Dec 2012 12:39:28 +0000, Bèrto ëd Sèra
<berto(dot)d(dot)sera(at)gmail(dot)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(dot)Bartolini(at)2ndQuadrant(dot)it - www.2ndQuadrant.it
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2012-12-13 16:06:07 | Re: Confuse about the behaveior of PreparedStatement.executeBatch (jdbc) |
| Previous Message | Bèrto ëd Sèra | 2012-12-13 12:39:28 | pooler/router? |