Search Postgresql Archives

Re: cloning database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux