Postgres Pro
Downloads
Home   >   mailing lists

Re: cloning database - Mailing list pgsql-general

From Craig Ringer
Subject Re: cloning database
Date
Msg-id 541C26AE.2020903@2ndquadrant.com
Whole thread Raw
In response to Re: cloning database  (hubert depesz lubaczewski <depesz@gmail.com>)
List pgsql-general
Tree view 
On 09/19/2014 07:04 PM, hubert depesz lubaczewski wrote:
>
>
> 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.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: ALTER TEXT field to VARCHAR(1024)
Next
From: Emanuel Calvo
Date:
Subject: Re: pg_multixact issues