Re: cloning database - Mailing list pgsql-general

On 2014-09-19 11:04:36 +0000, hubert depesz lubaczewski said:

On Fri, Sep 19, 2014 at 8:35 AM, Philipp Kraus <philipp.kraus@flashpixx.de> wrote:

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

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

Thanks a lot

Phil