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 6C0343A4015 for ; Mon, 25 Oct 2004 14:30:22 +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 86162-02 for ; Mon, 25 Oct 2004 13:30:09 +0000 (GMT) Received: from bcbssc.com (mail1.bcbssc.com [207.19.198.69]) by svr1.postgresql.org (Postfix) with ESMTP id 4C6F03A3FF3 for ; Mon, 25 Oct 2004 14:30:08 +0100 (BST) Received: from ([207.19.198.73]) by mail1.bcbssc.com with ESMTP id KP-TRPV8.5053362; Mon, 25 Oct 2004 09:29:05 -0400 X-Internal-ID: 417C824B000008A8 Received: from companiongroup.com (207.19.198.73) by companion1.companiongroup.com (NPlex 2.0.108); 25 Oct 2004 09:29:19 -0400 Message-ID: Date: Mon, 25 Oct 2004 09:26:00 -0400 From: "CHRIS HOOVER" To: Jodi Kanter Cc: Postgres Admin List MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="--:-Fischer-Intl-Naples,Fl-*MIX*-120302--5271:6aaf:6ea7--*GCS*" Subject: Re: db rename X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/330 X-Sequence-Number: 15323 This is the preamble of a multipart MIME formatted message. If you are reading this text your mail system is most likely not capable of properly decoding MIME messages. To extract the contents of this message, save it to a file and then use an external MIME decoding utility. --:-Fischer-Intl-Naples,Fl-*MIX*-120302--5271:6aaf:6ea7--*GCS* Content-Type: text/plain; charset="ISO-8859-1" Content-ID: Content-Transfer-Encoding: 8bit Content-Disposition: inline; filename="" syntax is: update pg_database set datname= where datname=; checkpoint; HTH, Chris ------------------( Forwarded letter 1 follows )--------------------- Date: Mon, 25 Oct 2004 08:59:03 -0400 To: Postgres.Admin.List[pgsql-admin]@postgresql.org.comp From: Jodi.Kanter[jkanter]@virginia.edu.comp Sender: pgsql-admin-owner+m15321@postgresql.org.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@virginia.edu --:-Fischer-Intl-Naples,Fl-*MIX*-120302--5271:6aaf:6ea7--*GCS* Content-Type: application/octet-stream; name="UnNamed.html" Content-ID: Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="UnNamed.html" PCFET0NUWVBFIGh0bWwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMDEg VHJhbnNpdGlvbmFsLy9FTiI+DQo8aHRtbD4NCjxoZWFkPg0KICA8bWV0YSBo dHRwLWVxdWl2PSJDb250ZW50LVR5cGUiIGNvbnRlbnQ9InRleHQvaHRtbDtj aGFyc2V0PUlTTy04ODU5LTEiPg0KICA8dGl0bGU+PC90aXRsZT4NCjwvaGVh ZD4NCjxib2R5IHRleHQ9IiMwMDAwMDAiIGJnY29sb3I9IiNmZmZmZmYiPg0K SSB0aG91Z2h0IHRoZXJlIHdhcyBhbiBvcHRpb24gdG8gcmVuYW1lIGEgZGF0 YWJhc2U/IEkgY2Fubm90IHNlZW0gdG8NCmZpbmQgdGhlIHN5bnRheCBpbiBh bnkgb2YgbXkgYm9va3Mgb3Igb24gdGhlIHdlYiBzaXRlLiBBbSBJIGluY29y cmVjdD8NCldlIGFyZSBydW5uaW5nIDcuMy40LiBXZSBoYXZlIHRvIGJyaW5n IG91ciBzeXRlbSBkb3duIHRvIHVwZ3JhZGUgdGhlDQpyZWxlYXNlIHRoaXMg YWZ0ZXJub29uLiBUaGVyZSBhcmUgYSBudW1iZXIgb2YgZGIgY2hhbmdlcyB0 YWtpbmcgcGxhY2UNCnNvIEkgd2FzIHRoaW5raW5nIGluc3RlYWQgb2YgdGFr aW5nIHRoZSBzeXN0ZW0gZG93biBmb3IgYW4gZXh0ZW5kZWQNCmFtb3VudCBv ZiB0aW1lIEkgY291bGQgYnVpbGQgYW5vdGhlciBkYXRhYmFzZSB3aXRoIGFs bCBvdXIgbmV3IGl0ZW1zDQphbmQgdGhlbiBqdXN0IHJlbmFtZSBpdCB3aGVu IHdlIGFyZSByZWFkeS48YnI+DQpJcyB0aGVyZSBhIHJlbmFtZSBvcHRpb24g b3V0IHRoZXJlIGZvciBvdXIgdmVyc2lvbj88YnI+DQp0aGFua3M8YnI+DQpK b2RpIDxicj4NCjxkaXYgY2xhc3M9Im1vei1zaWduYXR1cmUiPi0tIDxicj4N CjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0idGV4 dC9odG1sOyAiPg0KPG1ldGEgbmFtZT0iR2VuZXJhdG9yIiBjb250ZW50PSJN aWNyb3NvZnQgV29yZCAxMCAoZmlsdGVyZWQpIj4NCjx0aXRsZT5fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fPC90aXRsZT4NCjxzdHlsZT4NCjwh LS0NCiAvKiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KIHAuTXNvTm9ybWFsLCBs aS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCglt YXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJZm9udC1zaXplOjEyLjBwdDsNCglm b250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIjt9DQphOmxpbmssIHNwYW4u TXNvSHlwZXJsaW5rDQoJe2NvbG9yOmJsdWU7DQoJdGV4dC1kZWNvcmF0aW9u OnVuZGVybGluZTt9DQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9s bG93ZWQNCgl7Y29sb3I6cHVycGxlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRl cmxpbmU7fQ0KQHBhZ2UgU2VjdGlvbjENCgl7c2l6ZTo4LjVpbiAxMS4waW47 DQoJbWFyZ2luOjEuMGluIDEuMjVpbiAxLjBpbiAxLjI1aW47fQ0KZGl2LlNl Y3Rpb24xDQoJe3BhZ2U6U2VjdGlvbjE7fQ0KLS0+DQo8L3N0eWxlPg0KPGRp diBjbGFzcz0iU2VjdGlvbjEiPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PGk+ PHNwYW4NCiBzdHlsZT0iZm9udC1zaXplOiA5cHQ7IGZvbnQtZmFtaWx5OiBB cmlhbDsiPl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX188YnI+DQo8 L3NwYW4+PC9pPjxpPjxzcGFuIHN0eWxlPSJmb250LXNpemU6IDEwcHQ7Ij5K b2RpIEwgS2FudGVyPGJyPg0KQmlvSW5mb3JtYXRpY3MgRGF0YWJhc2UgQWRt aW5pc3RyYXRvcjxicj4NClVuaXZlcnNpdHkgb2YgVmlyZ2luaWE8YnI+DQoo NDM0KSA5MjQtMjg0Njxicj4NCjxhIGhyZWY9Im1haWx0bzpqa2FudGVyQHZp cmdpbmlhLmVkdTEwMCI+amthbnRlckB2aXJnaW5pYS5lZHU8L2E+PC9zcGFu PjwvaT48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj4mbmJzcDs8L3A+DQo8 L2Rpdj4NCjwvZGl2Pg0KPC9ib2R5Pg0KPC9odG1sPg0KDQo= --:-Fischer-Intl-Naples,Fl-*MIX*-120302--5271:6aaf:6ea7--*GCS*--