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

Re: db rename

From: "CHRIS HOOVER" <CHRIS(dot)HOOVER(at)companiongroup(dot)com>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: db rename
Date: 2004-10-25 13:26:00
Message-ID: NZ6b67d1-52716aaf@companiongroup.com (view raw or flat)
Thread:
Lists: pgsql-admin
syntax is:

update pg_database set datname=<new_name> where datname=<old_name>;
checkpoint;


HTH,

Chris
------------------( Forwarded letter 1 follows )---------------------
Date: Mon, 25 Oct 2004 08:59:03 -0400
To: Postgres(dot)Admin(dot)List[pgsql-admin](at)postgresql(dot)org(dot)comp
From: Jodi(dot)Kanter[jkanter](at)virginia(dot)edu(dot)comp
Sender: pgsql-admin-owner+m15321(at)postgresql(dot)org(dot)comp
Subject: [ADMIN] db rename

I thought there was an option to rename a database? I cannot seem to
find the syntax in any of my books or on the web site. Am I incorrect?
We are running 7.3.4. We have to bring our sytem down to upgrade the
release this afternoon. There are a number of db changes taking place so
I was thinking instead of taking the system down for an extended amount
of time I could build another database with all our new items and then
just rename it when we are ready.
Is there a rename option out there for our version?
thanks
Jodi
--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu100>






Attachment: UnNamed.html
Description: application/octet-stream (1.8 KB)

pgsql-admin by date

Next:From: Tsirkin EvgenyDate: 2004-10-25 13:42:02
Subject: Re: '<IDLE> in transaction' problem in mod_perl/DBI/DBD-Pg
Previous:From: Rajesh Kumar MallahDate: 2004-10-25 13:12:21
Subject: Re: db rename

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