Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cpHbI-0001jm-JB for pgsql-admin@arkaria.postgresql.org; Sat, 18 Mar 2017 16:53:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cpHbI-0000pK-5y for pgsql-admin@arkaria.postgresql.org; Sat, 18 Mar 2017 16:53:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cpHbH-0000nU-Gm for pgsql-admin@postgresql.org; Sat, 18 Mar 2017 16:53:07 +0000 Received: from adriana.opensysperu.com ([158.69.30.115]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cpHbE-00075T-7d for pgsql-admin@postgresql.org; Sat, 18 Mar 2017 16:53:06 +0000 Received: from localhost (localhost [IPv6:::1]) by adriana.opensysperu.com (Postfix) with ESMTP id E7B1D2103B; Sat, 18 Mar 2017 11:54:37 -0500 (PET) Received: from adriana.opensysperu.com ([IPv6:::1]) by localhost (adriana.opensysperu.com [IPv6:::1]) (amavisd-new, port 10032) with ESMTP id S_JXWw86gjPM; Sat, 18 Mar 2017 11:54:35 -0500 (PET) Received: from localhost (localhost [IPv6:::1]) by adriana.opensysperu.com (Postfix) with ESMTP id C4B5621047; Sat, 18 Mar 2017 11:54:35 -0500 (PET) X-Virus-Scanned: amavisd-new at opensysperu.com Received: from adriana.opensysperu.com ([IPv6:::1]) by localhost (adriana.opensysperu.com [IPv6:::1]) (amavisd-new, port 10026) with ESMTP id 4SRE2-VDuaZO; Sat, 18 Mar 2017 11:54:35 -0500 (PET) Received: from adriana.opensysperu.com (adriana.opensysperu.com [158.69.30.115]) by adriana.opensysperu.com (Postfix) with ESMTP id A75022103B; Sat, 18 Mar 2017 11:54:35 -0500 (PET) Date: Sat, 18 Mar 2017 11:54:35 -0500 (PET) From: Alvaro Aguayo Garcia-Rada To: bricklen Cc: pgsql-admin@postgresql.org, jasoninmel Message-ID: <30946781.200.1489855972019.JavaMail.Administrator@natalia-srv> In-Reply-To: References: <1489553982608-5949678.post@n3.nabble.com> <1398211489576882@web5g.yandex.ru> <1489721413358-5950172.post@n3.nabble.com> <1489721642262-5950175.post@n3.nabble.com> Subject: Re: Postgres - Replication MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [190.236.218.94] X-Mailer: Zimbra 8.6.0_GA_1153 (Zimbra Desktop/7.2.5_12038_Windows) Thread-Topic: Postgres - Replication Thread-Index: jlsU3M5Rk0/oE4hXObyhivR0MyiNnA== X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org I have some experience with BDR. Works fine. Alvaro Aguayo Jefe de Operaciones Open Comb Systems E.I.R.L. Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) 954183248 Website: www.ocs.pe ----- Original Message ----- From: "bricklen" To: "jasoninmel" Cc: pgsql-admin@postgresql.org Sent: Saturday, 18 March, 2017 11:41:48 AM Subject: Re: [ADMIN] Postgres - Replication On Thu, Mar 16, 2017 at 8:34 PM, jasoninmel < jasoninmel+1@gmail.com > wrote: Please note that I'm open for any other replication method that would allow better scalability. One of the best option would be to have Multi-master setup though I haven't seen any documentation around the support for such capability by Postgres. Postgresql doesn't support multi-master in the core project but there are options available. Have you come across BiDirectional Replication (BDR) yet? https://2ndquadrant.com/en/resources/bdr/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin