Skip site navigation (1) Skip section navigation (2)

Re: Clone a database to other machine

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: "Garg, Manjit" <mgarg(at)corbus(dot)com>
Cc: lists(at)stringsutils(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Clone a database to other machine
Date: 2008-07-30 14:52:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On 28/07/2008 18:32, Garg, Manjit wrote:

> But, actually I want to keep both the Databse in Sync. I want clone db
> to get the data from Master in  certain intervals.
> DB dump size is 3 GB.

In that case, a cron job which dumps the data from the master and 
reloads it on the other machine may be your best bet.


Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
Galway Cathedral Recitals:

In response to


pgsql-general by date

Next:From: Garg, ManjitDate: 2008-07-30 14:56:39
Subject: Re: Clone a database to other machine
Previous:From: Alvaro HerreraDate: 2008-07-30 14:51:44
Subject: Re: Connecting to an existing transaction state.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group