Home > mailing lists

Re: cloning database - Mailing list pgsql-general

From	hubert depesz lubaczewski
Subject	Re: cloning database
Date	September 19, 2014 14:04:43
Msg-id	CAKrjmhfXBjk=n+xzDk_fxpDf87fPFrCRPq=n2-4t4dyWLU2+ng@mail.gmail.com Whole thread Raw
In response to	cloning database (Philipp Kraus <philipp.kraus@flashpixx.de>)
Responses	Re: cloning database (Craig Ringer <craig@2ndquadrant.com>) Re: cloning database (David G Johnston <david.g.johnston@gmail.com>)
List	pgsql-general

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

From: Chris Travers
Date: 19 September 2014, 11:34:38
Subject: Re: Why isn't Java support part of Postgresql core?

From: Bill Moran
Date: 19 September 2014, 15:17:48
Subject: Re: ALTER TEXT field to VARCHAR(1024)