On Jul 20, 2014, at 11:09 AM, maillists0(at)gmail(dot)com wrote:
> I send a nightly dump of my production database to a development server. A script drops the existing development database and replaces it with the current production copy.
>
> Each dev uses her own copy of the database. Is there a way to copy the current development database to a differently named db on the same machine, including the data, without using the sql dump?
Look at CREATE DATABASE developer_db WITH TEMPLATE production_copy;
createdb with the --template option is a convenient way to do that from the commandline.
Cheers,
Steve