Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VjqwZ-0006Cq-IQ for pgsql-general@arkaria.postgresql.org; Fri, 22 Nov 2013 13:38:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VjqwY-0007YL-Pu for pgsql-general@arkaria.postgresql.org; Fri, 22 Nov 2013 13:38:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VjqwV-0007Tn-DV for pgsql-general@postgresql.org; Fri, 22 Nov 2013 13:38:43 +0000 Received: from mail-wi0-x231.google.com ([2a00:1450:400c:c05::231]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VjqwQ-0004sL-1b for pgsql-general@postgresql.org; Fri, 22 Nov 2013 13:38:43 +0000 Received: by mail-wi0-f177.google.com with SMTP id cc10so1203878wib.4 for ; Fri, 22 Nov 2013 05:38:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; bh=vV0NLsDEucUr7IvF3f8vLw+m9d1buuSx2ckw0ZvDAo4=; b=HqaDRclBY0ASuTEivql4/35xNM3f+lojRSoI1Hr01VWVvx8W0ZkoJRBpLGjfczkMvH Teb+EhMQnLJyqbWs9w+c3S96pGjv1DWCeCt94ODszMGV4TmlV+KGqnHp3t+6FC/hcgYN PBc3Pvt8XBlfLihn2Fl/kfyUAcv0COWlK1IMuWWT8f1Pwa69sgqe9S0s2zhMrkInD59f eEHKty8YhGX7LtQXYeGLWmqHcnC9JR0DUwmGyW62c5Mctjt5FS36JxNJhUXFwXfvu4Pg n+FtUvA3IMvF1C7OWj2O+nffodWRTbfS8MCv6WchahyDvDzpUZbnnVo+y8Hcprn4nE21 3KOw== MIME-Version: 1.0 X-Received: by 10.180.78.165 with SMTP id c5mr2706390wix.3.1385127516511; Fri, 22 Nov 2013 05:38:36 -0800 (PST) Received: by 10.180.75.111 with HTTP; Fri, 22 Nov 2013 05:38:36 -0800 (PST) In-Reply-To: References: <528F4BE2.7000400@gmx.net> Date: Fri, 22 Nov 2013 22:38:36 +0900 Message-ID: Subject: Re: PG replication across DataCenters From: Michael Paquier To: Albe Laurenz Cc: =?ISO-8859-1?Q?Torsten_F=F6rtsch_=2AEXTERN=2A?= , "Kaushal Shriyan *EXTERN*" , "pgsql-general@postgresql.org" Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On Fri, Nov 22, 2013 at 9:44 PM, Albe Laurenz wro= te: > Torsten F=F6rtsch wrote: >>> Don't use synchronous replication if you have a high transaction >>> rate and a noticable network latency between the sites. >>> >>> Wait for the next bugfix release, since a nasty bug has just >>> been discovered. >> >> Can you please explain or provide a pointer for more information? > > If you mean the bug I mentioned, see this thread: > http://www.postgresql.org/message-id/20131119142001.GA10498@alap2.anaraze= l.de Bug that has just been fixed btw: http://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcommitdiff;h=3D98f= 58a30c1beb6ec0870d6520f49fb40d9d0b566 Regards, --=20 Michael --=20 Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general