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 whole thread)
Thread:
Lists: pgsql-admin
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: <TAO(at)BCBSviaGCS@companion1.companiongroup.com120302-7d57:1449>
Content-Transfer-Encoding: 8bit
Content-Disposition: inline; filename=""

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>






--:-Fischer-Intl-Naples,Fl-*MIX*-120302--5271:6aaf:6ea7--*GCS*
Content-Type: application/octet-stream; 
	name="UnNamed.html"
Content-ID: <TAO(at)BCBSviaGCS@companion1.companiongroup.com120302-5d02:2899>
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*--


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-2016 The PostgreSQL Global Development Group