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