Thread: Rename a database

Is there a way rename a database?

I currently have a 'live' and a 'test' database.  For reasons I won't delve
into all the programs are currently using 'test'.  I want a quick way of
getting all the data into 'live'.  I am guessing I can shutdown the
postmaster and then move and/or copy directories in /usr/local/pgsql/data.
Can someone confirm this?


Bryan White
ArcaMax Inc.
Yorktown VA
www.arcamax.com