Re: db alias - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: db alias
Date
Msg-id 1338923090.1845.1.camel@localhost.localdomain
Whole thread Raw
In response to db alias  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On Tue, 2012-06-05 at 18:59 +0000, Gauthier, Dave wrote:
> Hi:  I think I know the answer to this, but the desire/need is great enough to get confirmation here.
>
> Is there a way to alias a db name for purposes of redirecting connections?   For example, you have 2 DBs, DBX and
DBY.The users always connect to a DB alias called "USEDB".   USEDB points to DBX today, changed to point to DBY
tomorrow,transparent to the users. 

PostgreSQL doesn't give you that, but pgBouncer may be the tool you're
looking for.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: db alias
Next
From: Aleksander Rozman
Date:
Subject: problem after upgrade db missing