Postgres Pro
Downloads
Home   >   mailing lists

Re: Clone a database to other machine - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Clone a database to other machine
Date
Msg-id 48908024.8030903@iol.ie
Whole thread Raw
In response to Re: Clone a database to other machine  ("Garg, Manjit" <mgarg@corbus.com>)
Responses Re: Clone a database to other machine
List pgsql-general
Tree view 
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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Connecting to an existing transaction state.
Next
From: Raymond O'Donnell
Date:
Subject: Re: Clone a database to other machine