From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Gauthier, Dave *EXTERN*" <dave(dot)gauthier(at)intel(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: db alias |
Date: | 2012-06-06 07:14:58 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C207F81289@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dave Gauthier wrote:
> 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.
That can easily be done using a connection service file on the client:
http://www.postgresql.org/docs/current/static/libpq-pgservice.html
Then you'd connect with "service=usedb".
To change the definition, you'd have to edit the file on the client.
If you don't want to modify the file on the client, you can use LDAP
connection parameter lookup:
http://www.postgresql.org/docs/current/static/libpq-ldap.html
That way you can change the definition centrally on the LDAP server.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-06-06 07:24:16 | Re: acessibility for tables |
Previous Message | Albe Laurenz | 2012-06-06 07:05:20 | Re: Partitioning Advice |