On 30/07/2008 15:56, Garg, Manjit wrote:
Actually I was looking for some method / tool (utility) which keeps both the database on different servers in sync automatically.
Ah, OK - I thought you meant that you needed a clone at specific intervals. You can use Slony (www.slony.info) to do this. A couple of caveats, however:
(i) If you use the 1.* version (the only currently stable version), you can't use pg_dump to dump from the slaves - this is because Slony 1.* rewrites the system catalogues in strange ways. :-)
(ii) Slony 2.0 (currently at RC1) does allow you to get a consistent dump from the slaves, but you need to be running PostgreSQL 8.3 or later.
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