[Bucardo-general] how to RENAME tables in postgres, replicated by bucardo

[Markova, Nina (NRCan/RNCan)]

Hello,

I need to RENAME couple of tables in postgres, which are  replicated via BUCARDO on MASTER-MASTER setup.
No change in the tables' structure or keys.

I need the renamed tables to stay replicated. How do I do it, what are the steps?

db1 (source)           db2 (source)
----------------          ---------------
Table 'abc'             'abc'

After the change:

db1 (source)           db2 (source)
----------------          ---------------
Table 'xyz'             'xyz'

In postgres I can do this by:
'alter table abc rename to xyz'
In Bucardo I see 'add table', 'remove table' commands.

Thanks in advance,
Nina
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170418/32cf7937/attachment.html>