Re: Vacuous errors in pg_dump ... | pg_restore pipeline

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.  :-)