On 01/23/2013 02:10 PM, Gauthier, Dave wrote:
Nope. Think of it this way, a new DB is created on day 1 of every month. So there's a DB called JAN, another called FEB, etc... . The DB name used in the connect is picked up from the current date/time. But January is oevr and I don't want to create the FEB DB until Feb 15th. In the meantime, I want those who try to connect to FEB to connect to JAN (for example).
-----Original Message-----
From: Joshua D. Drake [mailto:jd@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, January 23, 2013 4:04 PM
To: Gauthier, Dave
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: DB alias ?
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
alter database JAN rename to FEB;
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general