pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpooler/router?
2+ messages / 2 participants
[nested] [flat]
* pooler/router?
@ 2012-12-13 12:39 Bèrto ëd Sèra <berto.d.sera@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Bèrto ëd Sèra @ 2012-12-13 12:39 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pooler/router?
@ 2012-12-13 13:07 Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
parent: Bèrto ëd Sèra <berto.d.sera@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Gabriele Bartolini @ 2012-12-13 13:07 UTC (permalink / raw)
To: Bèrto ëd Sèra <berto.d.sera@gmail.com>; +Cc: pgsql-admin
Hi Bèrto,
On Thu, 13 Dec 2012 12:39:28 +0000, Bèrto ëd Sèra
<berto.d.sera@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.Bartolini@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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-12-13 13:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-12-13 12:39 pooler/router? Bèrto ëd Sèra <berto.d.sera@gmail.com>
2012-12-13 13:07 ` Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox