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