Gauthier, Dave wrote:
> Problem: Some users (scripts actually) try to connect to a DB who's name is derived from environmental variables.
TheDB doesn't exist (yet), and I want them to connect to a different DB for the time being. Is there a way to define
analias for the existing DB that = the db name that doesn't exist? Or is there a way to have PG fail over to a
defaultDB should a DB connect fail? I can implement the fail over outside PG, but those users who make a direct
connectto the DB don't use that code.
This has been requested previously. Probably the only reason it hasn't
gotten done yet is that nobody has cooked up a patch. Searching the
archives for "database synonyms" might be fruitful.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services