On Feb 20, 2008, at 2:12 PM, Douglas McNaught wrote:
Alternatively, is there a better way to streamline the duplication
of a
database?
How about:
CREATE DATABASE newdb TEMPLATE olddb;
The template DB has to have no open connections during the entire copy
process, so it is not always possible when the DB is big and/or busy.
But it is a wonderful way to snapshot development databases before
potentially breaking them with new features. :-)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
