[Bucardo-general] Add, Update, tables and columns.

[David Christensen]

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 <ami.ganguli at gmail.com> 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
> <pheriko.support at gmail.com> 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
>> <pheriko.support at gmail.com> 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
>> Bucardo-general at bucardo.org
>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general

--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171