cloning database

[Philipp Kraus]

Hello,

I need around 150 copies of a database (for an exam). I have got a
database with tables and data and for my exam I would copy this
database in his way:

database_source

database1
database2
….
database150

Is there a buildin way to clone the "database_source" with all
structure and data into a new database "database1..150" ?

Thanks a lot

Phil

[Alban Hertroys]

Post by Philipp Kraus
Hello,
database_source
database1
database2
….
database150
Is there a buildin way to clone the "database_source" with all structure and data into a new database "database1..150" ?

There is. You can use database_source as the template for creating new databases. There are a few restrictions, like the template database not being active, for example. See the docs for CREATE DATABASE and the createdb command.

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.

[Albe Laurenz]

Post by Philipp Kraus
I need around 150 copies of a database (for an exam). I have got a
database with tables and data and for my exam I would copy this
database_source
database1
database2
….
database150
Is there a buildin way to clone the "database_source" with all
structure and data into a new database "database1..150" ?

CREATE DATABASE database1 TEMPLATE database_source;

Yours,
Laurenz Albe

[hubert depesz lubaczewski]

Post by Philipp Kraus
Is there a buildin way to clone the "database_source" with all structure
and data into a new database "database1..150" ?

assuming you're using bash shell, this should work:

for i in {1..150}; do createdb -T database_source database$i; done

it's not a built-in, but very close.

depesz

[Craig Ringer]

Post by hubert depesz lubaczewski
for i in {1..150}; do createdb -T database_source database$i; done

Unless `datistemplate` is set for the database, you'll need to do this
as a superuser.

[Philipp Kraus]

On Fri, Sep 19, 2014 at 8:35 AM, Philipp Kraus
Is there a buildin way to clone the "database_source" with all
structure and data into a new database "database1..150" ?
for i in {1..150}; do createdb -T database_source database$i; done
it's not a built-in, but very close.
depesz

Thanks this is nice, to define a template and run the shell script

Thanks a lot

Phil

[David G Johnston]

On Fri, Sep 19, 2014 at 8:35 AM, Philipp Kraus <
>

Post by Philipp Kraus
Is there a buildin way to clone the "database_source" with all structure
and data into a new database "database1..150" ?

for i in {1..150}; do createdb -T database_source database$i; done
it's not a built-in, but very close.
depesz

Any advantage to this compared to using pl/pgsql via a DO command while
connected to the postgres database? Note it would require dynamic SQL
(i.e., EXECUTE).

David J.






--
View this message in context: http://postgresql.1045698.n5.nabble.com/cloning-database-tp5819599p5819805.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.