Re: Transaction-controlled robustness for replication - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Transaction-controlled robustness for replication
Date
Msg-id 200808121648.m7CGm8g20181@momjian.us
Whole thread Raw
In response to Re: Transaction-controlled robustness for replication  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs wrote:
> > What is the attraction of logical application of the WAL logs? 
> > Transmitting to a server with different architecture?
> 
> Yes,
> 
> * different release
> * different encoding
> * different CPU architecture
> * (with the correct transform) a different DBMS
> 
> So logical apply can provide a route for data transfer between
> applications, not just replication for DR or HA.
> 
> Physical apply works and will be more performant, but it will always be
> more restrictive. So there are arguments for doing it both ways.
> 
> I believe that we can and should offer both options to provide customer
> choice. Ideally, it would be nice to be able to switch between the two
> without significant reconfiguration, but that's definitely not for this
> release.

I assume you are focusing on physical first, becuase that is easiest.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Transaction-controlled robustness for replication
Next
From: Bruce Momjian
Date:
Subject: Re: Transaction-controlled robustness for replication