From: Om Prakash Jaiswal <op12om@yahoo.co.in>
To: bcc5226@gmail.com <bcc5226@gmail.com>
Cc: Pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Postgres - Replication
Date: Wed, 12 Jul 2017 08:26:21 +0000 (UTC)
Message-ID: <1451677064.4285950.1499847981519@mail.yahoo.com> (raw)
References: <1451677064.4285950.1499847981519.ref@mail.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Bacardo asynchronous tool is very good for master master as well as geographical distributed location.
RegardsOm Prakash.
Sent from Yahoo Mail on Android
On Tue, 21 Mar 2017 at 19:16, Poul Kristensen<bcc5226@gmail.com> wrote: If you redirect you syslog to another server, the "pg_log" will be written in/var/log/... and pg_log will just write that it has been redirected.
/Poul
2017-03-21 12:07 GMT+01:00 Michael@sqlexec.com <michael@sqlexec.com>:
BDR works fine for writeloads that are geographically separate. True multi-master is ACID compliant when you have a global transaction manager like Postgres-xc or Postgres-xl.
Regards
Sent from my iPad
On Mar 21, 2017, at 4:07 AM, Om Prakash Jaiswal <op12om@yahoo.co.in> wrote:
I am using Bucardo.It is working fine. It has been runinning for 5 years across 50 replicated nodes.I strongly recommend Bucardo for master-master replication.It is trigger based asynchronous replication system.
RegardsOm Prakash
On Saturday, 18 March 2017 10:24 PM, Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com> wrote:
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" <bricklen@gmail.com>
To: "jasoninmel" <jasoninmel+1@gmail.com>
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
--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: op12om@yahoo.co.in, bcc5226@gmail.com
Subject: Re: Postgres - Replication
In-Reply-To: <1451677064.4285950.1499847981519@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox