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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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