Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tj8Ve-0005Vv-T5 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Dec 2012 13:07:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tj8Ve-0002fR-CO for pgsql-admin@arkaria.postgresql.org; Thu, 13 Dec 2012 13:07:30 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tj8Vd-0002eY-9Q for pgsql-admin@postgresql.org; Thu, 13 Dec 2012 13:07:29 +0000 Received: from delta01.pnet.xcon.it ([62.48.53.16]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tj8Vb-0008MQ-TV for pgsql-admin@postgresql.org; Thu, 13 Dec 2012 13:07:28 +0000 Received: from localhost (localhost [127.0.0.1]) by delta01.pnet.xcon.it (Postfix) with ESMTP id E47491033A181; Thu, 13 Dec 2012 14:07:26 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at delta01.pnet.xcon.it Received: from delta01.pnet.xcon.it ([127.0.0.1]) by localhost (delta01.pnet.xcon.it [127.0.0.1]) (amavisd-new, port 10024) with LMTP id t0FIbtjBxcbJ; Thu, 13 Dec 2012 14:07:26 +0100 (CET) Received: from webmail.xcon.it (unknown [10.68.1.35]) (Authenticated sender: gabriele.bartolini@2ndquadrant.it) by delta01.pnet.xcon.it (Postfix) with ESMTPSA id 9B3661033A01B; Thu, 13 Dec 2012 14:07:26 +0100 (CET) Received: from eggIB-wan.comune.prato.it ([193.43.108.2]) by webmail.xcon.it with HTTP (HTTP/1.1 POST); Thu, 13 Dec 2012 14:07:26 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Date: Thu, 13 Dec 2012 14:07:26 +0100 From: Gabriele Bartolini To: =?UTF-8?Q?B=C3=A8rto_=C3=ABd_S=C3=A8ra?= Cc: Subject: Re: =?UTF-8?Q?pooler/router=3F?= In-Reply-To: References: Message-ID: X-Sender: Gabriele.Bartolini@2ndQuadrant.it User-Agent: [X]con Webmail/0.4.2 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi B=C3=A8rto, On Thu, 13 Dec 2012 12:39:28 +0000, B=C3=A8rto =C3=ABd S=C3=A8ra=20 wrote: > I was wondering whether there is anything I can drop in as a > "middleware", that will get any incoming connections to=20 > 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=20 different hosts. It is very light and open source:=20 http://wiki.postgresql.org/wiki/PgBouncer Cheers, Gabriele --=20 Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin