[Bucardo-general] DDL Changes -- How bucardo handles

[Greg Sabino Mullane]

> I have a question on DDL Changes. If there is a DDL change on the
> Master , Do we have to implement that change on the slave or is
> there way that Bucardo can detect it?

You have to implement it on the slaves manually. Postgres does not have
triggers on the system tables, which makes replication of DDL nigh
impossible to do automatically. Bucardo will warn you when you start up
if the tables do not have the same DDL, and will refuse to start the
sync if the differences are anything but non-trivial. There are future
plans to do some automatic syncing of DDL, but that's not happening any
time soon (unless someone sponsors the work, of course :)

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20091026/231c94f2/attachment.bin