Re: Postgres - Replication

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(at)sqlexec(dot)com <michael(at)sqlexec(dot)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(at)yahoo(dot)co(dot)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.
>
> Regards
> Om Prakash
>
>
>
> On Saturday, 18 March 2017 10:24 PM, Alvaro Aguayo Garcia-Rada <
> aaguayo(at)opensysperu(dot)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 <+51%201%203377813> | RPM: #034252 / (+51)
> 995540103 <+51%20995%20540%20103> | RPC: (+51) 954183248
> <+51%20954%20183%20248>
> Website: www.ocs.pe
>
> ----- Original Message -----
> From: "bricklen" <bricklen(at)gmail(dot)com>
> To: "jasoninmel" <jasoninmel+1(at)gmail(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)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(at)gmail(dot)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(at)postgresql(dot)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