[pgpool-general: 3661] Re: postgresql and pgpool - how best to set up a no data loss solution

[Derek]

The reason why I don't want to use a synchronous connection is because if the standby is slow, or is down, it freezes the master.

Kind regards,
Derek.

> On 27 Apr 2015, at 11:20 am, Christophe Pettus <xof at thebuild.com> wrote:
> 
> 
>> On Apr 26, 2015, at 6:10 PM, Derek <derek_kouch at yahoo.com.au> wrote:
>> 
>> Could setting up a pg_xlog folder synchronisation between the master and standby help with reducing the risk of data loss? Or would this cause potential data corruption?
> 
> It's unlikely that will do better than streaming replication by itself; the replication stream will almost always lead individual pg_xlog segments.  Synchronizing on sub-WAL-segment boundaries probably won't do much better.  In any event, those won't guarantee you won't lose a committed transaction.
> 
> If you simply cannot afford to lose a committed transaction, synchronous replication is your choice.
> --
> -- Christophe Pettus
>   xof at thebuild.com
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general