[pgpool-general: 3661] Re: postgresql and pgpool - how best to set up a no data loss solution
derek_kouch at yahoo.com.au
Mon Apr 27 10:28:52 JST 2015
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.
> 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
More information about the pgpool-general