From aa@devshock.com Fri Apr 1 12:54:04 2011 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 803BD1337B6E for ; Fri, 1 Apr 2011 09:54:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 55986-02 for ; Fri, 1 Apr 2011 12:53:47 +0000 (UTC) X-Greylist: delayed 00:27:53.808869 by SQLgrey-1.7.6 Received: from mail-gx0-f174.google.com (mail-gx0-f174.google.com [209.85.161.174]) by mail.postgresql.org (Postfix) with ESMTP id 7B98E1337B3E for ; Fri, 1 Apr 2011 09:53:46 -0300 (ADT) Received: by gxk21 with SMTP id 21so1381006gxk.19 for ; Fri, 01 Apr 2011 05:53:46 -0700 (PDT) Received: by 10.90.19.6 with SMTP id 6mr4277230ags.23.1301658954310; Fri, 01 Apr 2011 04:55:54 -0700 (PDT) Received: from AnibalVAIO ([190.128.222.90]) by mx.google.com with ESMTPS id t23sm2213868ano.51.2011.04.01.04.55.52 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 01 Apr 2011 04:55:53 -0700 (PDT) From: "Anibal David Acosta" To: Subject: Two way replication Date: Fri, 1 Apr 2011 08:55:52 -0300 Message-ID: <006401cbf063$c2122a30$46367e90$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0065_01CBF04A.9CC678D0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcvwYyrJgKiNUVr7QKu8/ut9DyjJqw== Content-Language: es-py X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.42 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72 X-Spam-Level: ** X-Archive-Number: 201104/13 X-Sequence-Number: 37194 This is a multipart message in MIME format. ------=_NextPart_000_0065_01CBF04A.9CC678D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello. I have two postgres 9.0 database both can be modified and both must have same information. In case of collision (same row changed in both) must win the most recent. Thanks. ------=_NextPart_000_0065_01CBF04A.9CC678D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello.

I have two postgres 9.0 = database both can be modified and both must have same = information.

In case of collision = (same row changed in both) must win the most = recent.

Thanks.

------=_NextPart_000_0065_01CBF04A.9CC678D0-- From Kevin.Grittner@wicourts.gov Fri Apr 1 13:46:57 2011 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 339111337B3E for ; Fri, 1 Apr 2011 10:46:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 39301-02 for ; Fri, 1 Apr 2011 13:46:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id B6D2613364DE for ; Fri, 1 Apr 2011 10:46:49 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Fri, 01 Apr 2011 08:46:49 -0500 Message-Id: <4D9590F4020000250003C0F8@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Fri, 01 Apr 2011 08:46:44 -0500 From: "Kevin Grittner" To: "Anibal David Acosta" , Subject: Re: Two way replication References: <006401cbf063$c2122a30$46367e90$@devshock.com> In-Reply-To: <006401cbf063$c2122a30$46367e90$@devshock.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.409 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: ** X-Archive-Number: 201104/16 X-Sequence-Number: 37197 "Anibal David Acosta" wrote: > I have two postgres 9.0 database both can be modified and both > must have same information. > > In case of collision (same row changed in both) must win the most > recent. If latency issues don't preclude it, pgpool might work for you. -Kevin