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

Re: Clone a database to other machine

From: "Garg, Manjit" <mgarg(at)corbus(dot)com>
To: <rod(at)iol(dot)ie>
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:56:39
Message-ID: 71533CF615F98646AC7B1C66B0F5158B0411F45D@hercules.corbus.com (view raw or flat)
Thread:
Lists: pgsql-general
 Hi ,

Actually I was looking for some method / tool (utility) which keeps both
the database on different servers in sync automatically.

Looking for some features into postgres.conf file if possible. 


Thanks and regards,

Manjit Garg


-----Original Message-----
From: Raymond O'Donnell [mailto:rod(at)iol(dot)ie] 
Sent: Wednesday, July 30, 2008 8:22 PM
To: Garg, Manjit
Cc: lists(at)stringsutils(dot)com; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Clone a database to other machine

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: Raymond O'DonnellDate: 2008-07-30 15:07:53
Subject: Re: Clone a database to other machine
Previous:From: Raymond O'DonnellDate: 2008-07-30 14:52:20
Subject: Re: Clone a database to other machine

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