Downloads
Home   >   mailing lists

Re: database name aliases? - Mailing list pgsql-general

From Woody Woodring
Subject Re: database name aliases?
Date
Msg-id [email protected]
Whole thread Raw
In response to database name aliases?  (Reece Hart <[email protected]>)
Responses Re: database name aliases?
List pgsql-general
Tree view
We use the pg_services.conf file.
 
 
In the file you can point the alias to whatever db you want.  To connect:
 
[bash]$ PGSERIVCE=dbname psql
 
Woody
IGLASS Networks

From: [email protected] [mailto:[email protected]] On Behalf Of Reece Hart
Sent: Monday, November 06, 2006 6:07 PM
To: pgsql-general
Subject: [GENERAL] database name aliases?

I'd like to be able to have several versions of a database available concurrently and one database alias that refers to the most recent of these.  For example:

dbname_1-1
dbname_1-2
dbname_1-3
dbname -> dbname_1-3

and
$ psql -d dbname
would connect to dbname_1-3.

Any ideas?

Thanks,
Reece

-- 
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: X.50x OID representation
Next
From: Ron Peterson
Date:
Subject: when to use pfree?