Marko Kreen wrote:
> On 10/11/07, Alexey Klyukin <[EMAIL PROTECTED]> 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?

No, we need a table to have primary key to be able to replicate it. From
the other hand replicating a system relation can be dangerous, i.e. what if
you replicate the contents of pg_class without corresponing relations on the 
slave, that's why explicitly forbid enabling replication for relations from 
pg_catalog namespace.

Alexey Klyukin               
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to