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:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2008 8:22 PM To: Garg, Manjit Cc: [EMAIL PROTECTED]; 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 [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general