Search Postgresql Archives

Re: db alias

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux