db rename

[Jodi Kanter]

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

[Tom Lane]

Post by Jodi Kanter
I thought there was an option to rename a database?

No, but you could always do an UPDATE on pg_database. It might be a
good idea to ensure there are no backends running in the target database
when you do the update. (I think that recent releases wouldn't care
particularly, but I'm less sure about 7.3.4.)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org