Rename a database - Mailing list pgsql-general

From Bryan White
Subject Rename a database
Date
Msg-id 00cb01be5b75$9faa6c40$a3f0f6ce@bryan.arcamax.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Adriaan Joubert
Date:
Subject: Error in querying view
Next
From: Edmund Mergl
Date:
Subject: [Fwd: Help with Postgres]