Discussion:
Copying a database.
m***@gmail.com
2014-07-20 18:09:42 UTC
Permalink
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?
Steve Atkins
2014-07-20 18:28:27 UTC
Permalink
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
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Adrian Klaver
2014-07-20 18:54:16 UTC
Permalink
Post by Steve Atkins
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;
Just be aware of this caveat:

http://www.postgresql.org/docs/9.3/interactive/sql-createdatabase.html

"Although it is possible to copy a database other than template1 by
specifying its name as the template, this is not (yet) intended as a
general-purpose "COPY DATABASE" facility. The principal limitation is
that no other sessions can be connected to the template database while
it is being copied. CREATE DATABASE will fail if any other connection
exists when it starts; otherwise, new connections to the template
database are locked out until CREATE DATABASE completes. See Section
21.3 for more information."
Post by Steve Atkins
createdb with the --template option is a convenient way to do that from the commandline.
Cheers,
Steve
--
Adrian Klaver
***@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Loading...