Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A042B2E2F93 for ; Wed, 6 Feb 2008 15:42:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00567-03 for ; Wed, 6 Feb 2008 15:42:33 -0400 (AST) Received: from n9a.bullet.ukl.yahoo.com (n9a.bullet.ukl.yahoo.com [217.146.183.157]) by postgresql.org (Postfix) with SMTP id 9174D2E2D8B for ; Wed, 6 Feb 2008 15:42:32 -0400 (AST) Received: from [217.12.4.214] by n9.bullet.ukl.yahoo.com with NNFMP; 06 Feb 2008 19:42:30 -0000 Received: from [216.252.122.219] by t1.bullet.ukl.yahoo.com with NNFMP; 06 Feb 2008 19:42:30 -0000 Received: from [69.147.65.169] by t4.bullet.sp1.yahoo.com with NNFMP; 06 Feb 2008 19:42:27 -0000 Received: from [127.0.0.1] by omp504.mail.sp1.yahoo.com with NNFMP; 06 Feb 2008 19:42:27 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 186010.85930.bm@omp504.mail.sp1.yahoo.com Received: (qmail 93310 invoked by uid 60001); 6 Feb 2008 19:42:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=nAFqIZv021A/hr06GSCAkoWv6WaWyyr2t8oSAFlY7GTR1Lj2JAWv8P8TdDLm/YTRatiTKyBJd6CG1GEEvuh8LwCeQp88Zj4dpdXj+hy0NWGgy1iOTqSHfMQJEj+TtWUCyvECXYHkHOlRE90lozSXr5v5n7mWnWtjtZprfs2lqUY=; X-YMail-OSG: uMTEn4gVM1kfl6RQKePiu_ESEMdp0JnHLc4qqYOYlWdP8j2YgLUmoJYHGBOoSMlE1JRozH.Vn126up.VG5ZvlQFE3w-- Received: from [128.8.215.134] by web46005.mail.sp1.yahoo.com via HTTP; Wed, 06 Feb 2008 11:42:26 PST Date: Wed, 6 Feb 2008 11:42:26 -0800 (PST) From: Nuwan Liyanage Subject: rename database To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-521168758-1202326946=:93056" Content-Transfer-Encoding: 8bit Message-ID: <952808.93056.qm@web46005.mail.sp1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/65 X-Sequence-Number: 28139 --0-521168758-1202326946=:93056 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I am trying to rename my database; I used the following command, Alter database postgres rename to post_dev; but I get a error saying that the "current database may not be renamed" I look at the documentation, and it says that I need to connect to a different database in order do that? can someone please help me how to do that.. Thanks alnuwan --------------------------------- Never miss a thing. Make Yahoo your homepage. --0-521168758-1202326946=:93056 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi,
       I am trying to rename my database; I used the following command,
Alter database postgres rename to post_dev;
but I get a error saying that the "current database may not be renamed"
I look at the documentation, and it says that I need to connect to a different database in order do that?
can someone please help me how to do that..
Thanks
alnuwan


Never miss a thing. Make Yahoo your homepage. --0-521168758-1202326946=:93056--