Re: cloning database

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: hubert depesz lubaczewski <depesz(at)gmail(dot)com>, Philipp Kraus <philipp(dot)kraus(at)flashpixx(dot)de>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: cloning database
Date: 2014-09-19 12:50:54
Message-ID: 541C26AE.2020903@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emanuel Calvo 2014-09-19 13:44:25 Re: pg_multixact issues
Previous Message Bill Moran 2014-09-19 12:16:00 Re: ALTER TEXT field to VARCHAR(1024)