Re: DB alias ? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: DB alias ?
Date
Msg-id 51005053.50709@commandprompt.com
Whole thread Raw
In response to DB alias ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: DB alias ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On 01/23/2013 12:45 PM, Gauthier, Dave wrote:
> 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.

Pass the database name when you connect?

JD


>
> Thanks in Advance
>


--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: DB alias ?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: DB alias ?