Re: DB alias ?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: DB alias ?
Date: 2013-01-23 21:04:19
Message-ID: 51005053.50709@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • DB alias ? at 2013-01-23 20:45:53 from Gauthier, Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2013-01-23 21:10:13 Re: DB alias ?
Previous Message Alvaro Herrera 2013-01-23 20:54:21 Re: DB alias ?