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@iol.ie]
Sent: Wednesday, July 30, 2008 8:22 PM
To: Garg, Manjit
Cc: lists@stringsutils.com; pgsql-general@postgresql.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@iol.ie Galway Cathedral Recitals:
http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
