Thread: DATABASE CLONNING

DATABASE CLONNING

From
"JORGE MALDONADO"
Date:
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 ???

Re: DATABASE CLONNING

From
Mark Roberts
Date:
Unless you need to be generating these databases on the fly, you might
consider Slony for your database replication needs http://slony.info/

Essentially, what I mean is that you create said databases, and slony
keeps them in sync (as replicas of the master database).

-Mark

On Wed, 2008-06-11 at 10:43 -0500, JORGE MALDONADO 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 ???


Re: DATABASE CLONNING

From
Alan Hodgson
Date:
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