Re: BDR truncate and replication sets

From: Sylvain MARECHAL <marechal(dot)sylvain2(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: BDR truncate and replication sets
Date: 2015-09-17 07:17:16
Message-ID: 55FA68FC.6030302@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 15/09/2015 18:56, Alvaro Herrera a écrit :
> Sylvain MARECHAL wrote:
>> [...] The exception is with TRUNCATE: In case it is called, data is removed on
>> both nodes.
>>
>> Is it a feature or a bug?
> I think it's an oversight. Replication sets were added later than the
> TRUNCATE trigger, so the design for the latter does not consider the
> former as far as I know.
Ok. May I fill a bug report?
>> [...] Is there a workaround?
>> (deleting the truncate trigger seems to work, but I am sure it is safe to do
>> it)
> Well, the truncate trigger is there to replicate the truncate to other
> servers. If you don't want truncate to be propagated, dropping the
> trigger is one way to achieve that effect.
>
Ok. That is what I will do.
In fact, having TRUNCATE do its job on all nodes is sometimes useful,
sometimes unwanted. So this workaround is perfect for me for the moment.

Thank you,
Sylvain

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raman, Karthik IN BLR STS 2015-09-17 07:31:18 Online backup of PostgreSQL data.
Previous Message Venkata Balaji N 2015-09-17 06:24:52 Re: Import Problem