On Jul 20, 2014, at 11:09 AM, maillists0@xxxxxxxxx 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
