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

From Marko Kreen
Subject Re: Some questions about mammoth replication
Date
Msg-id e51f66da0710110853y35abd60bi1992d1eee8de4be8@mail.gmail.com
Whole thread Raw
In response to Re: Some questions about mammoth replication  (Alexey Klyukin <alexk@commandprompt.com>)
Responses Re: Some questions about mammoth replication
List pgsql-hackers
On 10/11/07, Alexey Klyukin <alexk@commandprompt.com> wrote:
> Hannu Krosing 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 (I don't know if Skytools can). Replicator doesn't have this
> limitation.

No, Skytools is same as Slony.

Can you also replicate changes to system tables?

-- 
marko


pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Some questions about mammoth replication
Next
From: Tom Lane
Date:
Subject: Re: full text search in 8.3