Skip site navigation (1) Skip section navigation (2)

database aliases?

From: Reece Hart <rkh(at)gene(dot)COM>
To: sfpug(at)postgresql(dot)org
Subject: database aliases?
Date: 2003-04-04 23:45:11
Message-ID: 1049499911.1732.28.camel@tallac (view raw or flat)
Thread:
Lists: sfpug
Does anyone know if there's a way to create a database alias?  What I'm
after is an easy way to archive older versions of a database (data,
schema, functions, etc) as well as facilitate the dev->stage->production
cycle.

For example, I'd like to be able to name databases like

db-1.0
db-1.1
db-1.2

and have a `db' alias which points to the most recent, while still
allowing users to login directly to a version, e.g., to `db-1.1'.

Thanks,
Reece

-- 
Reece Hart, Ph.D.                       rkh(at)gene(dot)com, http://www.gene.com/
Genentech, Inc.                         650/225-6133 (voice), -5389 (fax)
Bioinformatics and Protein Engineering
1 DNA Way, MS-93                        http://www.in-machina.com/~reece/
South San Francisco, CA  94080-4990     reece(at)in-machina(dot)com, GPG: 0x25EC91A0


Responses

sfpug by date

Next:From: David FetterDate: 2003-04-05 02:51:10
Subject: Re: database aliases?
Previous:From: Dror MatalonDate: 2003-04-04 19:28:02
Subject: Bloki, a new Zapatec service

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group