DB alias ? - Mailing list pgsql-general

From Gauthier, Dave
Subject DB alias ?
Date
Msg-id 0AD01C53605506449BA127FB8B99E5E16112D00C@FMSMSX105.amr.corp.intel.com
Whole thread Raw
Responses Re: DB alias ?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: DB alias ?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general

Problem:  Some users (scripts actually) try to connect to a DB who's name is derived from environmental variables.  The DB doesn't exist (yet), and I want them to connect to a different DB for the time being.  Is there a way to define an alias for the existing DB that = the db name that doesn't exist?    Or is there a way to have PG fail over to a default DB should a DB connect fail?  I can implement the fail over outside PG, but those users who make a direct connect to the DB don't use that code.

 

Thanks in Advance 

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Trouble with Postgresql RPM
Next
From: Alvaro Herrera
Date:
Subject: Re: DB alias ?