Re: Database alias - Mailing list pgsql-admin

From Igor Neyman
Subject Re: Database alias
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A207F8B655@EXCHANGE.corp.perceptron.com
Whole thread Raw
In response to Re: Database alias  (Florian Weimer <fweimer@bfk.de>)
Responses Re: Database alias  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
> -----Original Message-----
> From: Florian Weimer [mailto:fweimer@bfk.de]
> Sent: Wednesday, August 24, 2011 5:00 AM
> To: Gabriele Bartolini
> Cc: pgsql-admin@postgresql.org
> Subject: Re: Database alias
>
> * Gabriele Bartolini:
>
> > On Wed, 24 Aug 2011 08:30:34 +0000, Florian Weimer <fweimer@bfk.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@bfk.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.

Regards,
Igor Neyman

pgsql-admin by date:

Previous
From: Diego Augusto Molina
Date:
Subject: Re: RV: Recuperar una base de datos en un tablespace en otro servidor
Next
From: Scott Marlowe
Date:
Subject: Re: Database alias