Expanding on this, Bucardo has traditionally considered DDL structure changes like this out of its purview.
In particular: - DDL changes like this tend to be pretty infrequent relative to just regular replication/data events, so generally assume a static schema (i.e., you’re in production mode) - You often want to control the impacts/timing of such events, such as locks, and having an external tool manage this leads to less control in the situation - Bucardo doesn’t require identical structures on each side of replication, for instance you can push to a table which has additional fields in it - You can manage modifying the nodes just using regular migration scripts, e.g.: bucardo stop; for db in master replica1 replica2; do psql -h $db -d database -f modifications.sql; done; bucardo start HTH, David > On Feb 21, 2017, at 12:27 PM, Ami Ganguli <[email protected]> wrote: > > Hi, > > If you mean that you want table and column additions/deletions to > replicate, I don't think that's possible at the moment. > > Postgresql 9.3 added event triggers, which should make it possible to > implement something like this. Apparently BDR does this, and maybe > that will work for you if you're able to use it. > > What's your use-case exactly? > > Cheers, > Ami. > > On Tue, Feb 21, 2017 at 1:04 PM, Periko Support > <[email protected]> wrote: >> Hi. >> >> If someone can give us support for this, we can give $$$ back. >> >> Thanks. >> >> On Wed, Feb 15, 2017 at 11:06 AM, Periko Support >> <[email protected]> wrote: >>> Hi. >>> >>> Developers now know the power of bucardo, is doing no other tools can >>> do this way. >>> >>> But our developers what to do this: >>> >>> Add/Delete tables. >>> Add/Delete columns >>> >>> I'm doing reengineering to understand how to manage this with bucardo. >>> >>> But if some could share the steps to: >>> >>> a) Add/Delete new tables. >>> b) Add/Delete columns >>> >>> I will appreciated any help here. >>> >>> The main goal is done, now people want more, thanks guys. >> _______________________________________________ >> Bucardo-general mailing list >> [email protected] >> https://mail.endcrypt.com/mailman/listinfo/bucardo-general > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general -- David Christensen End Point Corporation [email protected] 785-727-1171 _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
