Re: DATABASE CLONNING - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: DATABASE CLONNING
Date
Msg-id 200806110928.51973@hal.medialogik.com
Whole thread Raw
In response to DATABASE CLONNING  ("JORGE MALDONADO" <jorgemal1960@gmail.com>)
List pgsql-novice
On Wednesday 11 June 2008, "JORGE MALDONADO" <jorgemal1960@gmail.com> wrote:
> I am developing an application in which I need to create several equal
> databases based on one that I will take as standard. What I mean is that
> I will create one basic empty complete database (including table,
> constrains, indexes, etc.) and from here I need to clone other databases
> which will be part of the production application.
> Is it possible to do it ???

You can use an existing database as a template when creating new databases
(as, indeed, template1 is used by default). See the -T option to createdb.

--
Alan

pgsql-novice by date:

Previous
From: Mark Roberts
Date:
Subject: Re: DATABASE CLONNING
Next
From: "Ram Ravichandran"
Date:
Subject: combining multiple partial indices