X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 43DF33A403A for ; Mon, 25 Oct 2004 14:11:16 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78325-03 for ; Mon, 25 Oct 2004 13:11:06 +0000 (GMT) Received: from trade-india.com (unknown [203.101.29.36]) by svr1.postgresql.org (Postfix) with SMTP id A6C563A4052 for ; Mon, 25 Oct 2004 14:11:03 +0100 (BST) Received: (qmail 23369 invoked from network); 25 Oct 2004 13:05:16 -0000 Received: from system100.trade-india-local.com (HELO ?192.168.0.100?) (192.168.0.100) by system66.trade-india-local.com with SMTP; 25 Oct 2004 13:05:16 -0000 Message-ID: <417CFBB5.9090907@trade-india.com> Date: Mon, 25 Oct 2004 18:42:21 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jodi Kanter Cc: Postgres Admin List Subject: Re: db rename References: <417CF897.1020701@virginia.edu> In-Reply-To: <417CF897.1020701@virginia.edu> Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_50_60, HTML_MESSAGE, HTML_TITLE_EMPTY, MIME_HTML_ONLY X-Spam-Level: X-Archive-Number: 200410/329 X-Sequence-Number: 15322
Dear Jodi,


psql>\h CREATE DATABASE
Command:     CREATE DATABASE
Description: create a new database
Syntax:
CREATE DATABASE name
    [ [ WITH ] [ OWNER [=] dbowner ]
           [ LOCATION [=] 'dbpath' ]
           [ TEMPLATE [=] template ]
           [ ENCODING [=] encoding ] ]

tradein_clients=#


You might consider using the TEMPLATE=template option
by default its template1 , if you put the existing database name
a replica of specified database is made

Hope it helps.

Regds
Mallah.

Jodi Kanter wrote:
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@virginia.edu

 



-- 

regds
Mallah.

Rajesh Kumar Mallah
+---------------------------------------------------+
| Tradeindia.com  (3,11,246) Registered Users 	    | 
| Indias' Leading B2B eMarketPlace                  |
| http://www.tradeindia.com/			    |
+---------------------------------------------------+