Skip site navigation (1) Skip section navigation (2)

Re: Database alias

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: Florian Weimer <fweimer(at)bfk(dot)de>, Gabriele Bartolini <Gabriele(dot)Bartolini(at)2ndquadrant(dot)it>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Database alias
Date: 2011-08-26 03:14:17
Message-ID: CAOR=d=0Z7j1fbqRag6eAei7WvpAp+zCuB4p6vzRPkzrwX5+G6Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Aug 25, 2011 at 7:17 AM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:
>> -----Original Message-----
>> From: Florian Weimer [mailto:fweimer(at)bfk(dot)de]
>> Sent: Wednesday, August 24, 2011 5:00 AM
>> To: Gabriele Bartolini
>> Cc: pgsql-admin(at)postgresql(dot)org
>> Subject: Re: Database alias
>>
>> * Gabriele Bartolini:
>>
>> > On Wed, 24 Aug 2011 08:30:34 +0000, Florian Weimer <fweimer(at)bfk(dot)de>
>> > 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-)
>>
>> --
>> Florian Weimer                <fweimer(at)bfk(dot)de>
>> BFK edv-consulting GmbH       http://www.bfk.de/
>> Kriegsstraße 100              tel: +49-721-96201-1
>> D-76133 Karlsruhe             fax: +49-721-96201-99
>
> PgBouncer is the easiest piece of software to install and to manage I've ever dealt with, and it's very light on system resources.

Agreed it's much less complex than hacking the server code to make one
db name seem like another.

In response to

pgsql-admin by date

Next:From: Craig RingerDate: 2011-08-26 04:14:25
Subject: Re: Question on Postgres Index internals
Previous:From: mnk722Date: 2011-08-25 14:53:44
Subject: problem during installation of pgpool-Admin-3.0.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group