Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7BA8FB5DBC6 for ; Wed, 24 Aug 2011 05:59:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 40996-08 for ; Wed, 24 Aug 2011 08:59:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by mail.postgresql.org (Postfix) with ESMTP id C77FAB5DBE9 for ; Wed, 24 Aug 2011 05:59:47 -0300 (ADT) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) id 1Qw9JK-0000Qy-FK; Wed, 24 Aug 2011 08:59:46 +0000 Received: by bfk.de with local id 1Qw9JK-0006rt-CS; Wed, 24 Aug 2011 08:59:46 +0000 From: Florian Weimer To: Gabriele Bartolini Cc: Subject: Re: Database alias References: <82ippnky8l.fsf@mid.bfk.de> Date: Wed, 24 Aug 2011 08:59:46 +0000 In-Reply-To: (Gabriele Bartolini's message of "Wed, 24 Aug 2011 10:54:26 +0200") Message-ID: <82aaazkwvx.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.405 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.505 X-Spam-Level: X-Archive-Number: 201108/199 X-Sequence-Number: 38186 * Gabriele Bartolini: > On Wed, 24 Aug 2011 08:30:34 +0000, Florian Weimer > wrote: >> We've got some systems which use a historic database name and would >> like to transition them to our current naming scheme. Is there >> support for some form of database aliases? > > If you are trying to make the database seen by clients under a > different name, probably the most practical solution would be to add a > PgBouncer layer in front of the clients which maps the old database > name to the new one. > > http://wiki.postgresql.org/wiki/PgBouncer Ah, that would probably work at a technical level, thanks. But in this particular case, my aim is to avoid additional complexity, and installing PgBouncer seems to be at odds with this goal. 8-) --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99