X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id F403ED1B561 for ; Sun, 31 Aug 2003 00:23:19 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 75779-01 for ; Sat, 30 Aug 2003 21:22:52 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 1A56BD1B574 for ; Sat, 30 Aug 2003 21:22:49 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h7V0Mnek061574 for ; Sun, 31 Aug 2003 00:22:49 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h7UNu5Xt057000 for pgsql-admin@postgresql.org; Sat, 30 Aug 2003 23:56:05 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Replication Date: Sat, 30 Aug 2003 19:47:22 -0400 Organization: cbbrowne Computing Inc Lines: 32 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Rational FORTRAN, linux) Cancel-Lock: sha1:I5xq0AaPg/t85MI5gt0Oi3QI9es= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/367 X-Sequence-Number: 10087 Martha Stewart called it a Good Thing whenianh@hubspan.com ("Ian Huynh")wrote: > Seems that there are a number of simultaneous project in trying to implement replication > for postgres. > > Is anyone out there using this feature currently? If so , which package & OS environment. > > the latest news was eRServer v1.0. Is this the same as the v1.2 that Postgres INC announced > early this year ? > > Is there a master-master capability or only master-multi-slave ? The version of eRServer recently released as free software is not the latest "production" release, but it is a direct predecessor. Its operational model is that of "master/possible multiple slaves," NOT multimaster. Multimaster involves some thorny issues surrounding synchronization, as it is possible for one master to receive a set of changes concurrently with another master receiving _incompatible_ changes. PalmOS users see this if they change a particular record on both desktop and palmtop; the next time they sync, the conflicting record normally gets duplicated and the user gets to decide how to fix it. Doing that in a big production database context may not be possible/acceptable. You only should do multimaster if you REALLY know what you're doing. -- select 'aa454' || '@' || 'freenet.carleton.ca'; http://www.ntlug.org/~cbbrowne/sap.html Do you know where your towel is?