pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase alias
5+ messages / 4 participants
[nested] [flat]
* Database alias
@ 2011-08-24 08:30 Florian Weimer <fweimer@bfk.de>
0 siblings, 1 reply; 5+ messages in thread
From: Florian Weimer @ 2011-08-24 08:30 UTC (permalink / raw)
To: pgsql-admin
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?
The alias doesn't need to be visible in server responses, so we could
probably add a kludge to the server code which rewrites the database
name in incoming connection requests. 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database alias
@ 2011-08-24 08:54 Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
parent: Florian Weimer <fweimer@bfk.de>
0 siblings, 1 reply; 5+ messages in thread
From: Gabriele Bartolini @ 2011-08-24 08:54 UTC (permalink / raw)
To: Florian Weimer <fweimer@bfk.de>; +Cc: pgsql-admin
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
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database alias
@ 2011-08-24 08:59 Florian Weimer <fweimer@bfk.de>
parent: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
0 siblings, 1 reply; 5+ messages in thread
From: Florian Weimer @ 2011-08-24 08:59 UTC (permalink / raw)
To: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>; +Cc: pgsql-admin
* 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database alias
@ 2011-08-25 13:17 Igor Neyman <ineyman@perceptron.com>
parent: Florian Weimer <fweimer@bfk.de>
0 siblings, 1 reply; 5+ messages in thread
From: Igor Neyman @ 2011-08-25 13:17 UTC (permalink / raw)
To: Florian Weimer <fweimer@bfk.de>; Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>; +Cc: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Database alias
@ 2011-08-26 03:14 Scott Marlowe <scott.marlowe@gmail.com>
parent: Igor Neyman <ineyman@perceptron.com>
0 siblings, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2011-08-26 03:14 UTC (permalink / raw)
To: Igor Neyman <ineyman@perceptron.com>; +Cc: Florian Weimer <fweimer@bfk.de>; Gabriele Bartolini <Gabriele.Bartolini@2ndquadrant.it>; pgsql-admin
On Thu, Aug 25, 2011 at 7:17 AM, Igor Neyman <ineyman@perceptron.com> wrote:
>> -----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.
Agreed it's much less complex than hacking the server code to make one
db name seem like another.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2011-08-26 03:14 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-24 08:30 Database alias Florian Weimer <fweimer@bfk.de>
2011-08-24 08:54 ` Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
2011-08-24 08:59 ` Florian Weimer <fweimer@bfk.de>
2011-08-25 13:17 ` Igor Neyman <ineyman@perceptron.com>
2011-08-26 03:14 ` Scott Marlowe <scott.marlowe@gmail.com>
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