Re: Slightly OT. - Mailing list pgsql-general

From Tom Lane
Subject Re: Slightly OT.
Date
Msg-id 22491.1180727455@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slightly OT.  ("Alexander Staubo" <alex@purefiction.net>)
List pgsql-general
"Alexander Staubo" <alex@purefiction.net> writes:
> On 6/1/07, Jeff Davis <pgsql@j-davis.com> wrote:
>> To be fair to Slony-I, the fact that it does not replicate DDL is a
>> feature, not a bug. It's table-based, which is a very flexible design.

> I fail to see how that's an excuse not to replicate DDL.
> I could be wrong, but I believe Slony fails at this because it is
> trigger-based and simply cannot detect DDL changes.

You are wrong.  The Slony guys say this is intentional, and they have
some good arguments.  They may be making a virtue of necessity, but
automatic replication of DDL is not nearly as open-and-shut a decision
as you paint it.

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: multimaster (was: Slightly OT.)
Next
From: Tom Lane
Date:
Subject: Re: collision in serial numbers after INSERT?