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: 48908024.8030903@iol.ie (view raw or flat)
Thread:
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.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Responses

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-2014 The PostgreSQL Global Development Group