Re: Some questions about mammoth replication - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: Some questions about mammoth replication
Date
Msg-id 470E4586.9000704@pse-consulting.de
Whole thread Raw
In response to Re: Some questions about mammoth replication  (Alexey Klyukin <alexk@commandprompt.com>)
List pgsql-hackers
Alexey Klyukin wrote:
>
>   
>> For what use cases do you think your WAL-based approach is better than
>> Slony/Skytools trigger-based one ?
>>     
>
> A pure trigger based approach can only replicate data for the commands
> which fire triggers. AFAIK Slony is unable to replicate TRUNCATE
> command
It could be wrapped with ddl_script which obviously isn't transparent to
the application, but I guess a table that's truncated regularly won't be
a typical candidate  for (async) replication either.

Regards,
Andreas



pgsql-hackers by date:

Previous
From: Alexey Klyukin
Date:
Subject: Re: Some questions about mammoth replication
Next
From: "Marko Kreen"
Date:
Subject: Re: Some questions about mammoth replication