Christopher Browne cbbrowne at afilias.info
Thu Dec 17 13:21:15 PST 2015
On Thu, Dec 17, 2015 at 1:50 PM, "Gonzalo Vásquez @ Waypoint" <
gvasquez at waypoint.cl> wrote:
>
> Can one specify a wildcard in the list of tables, or perhaps a whole
schema for replication instead of enumerating the whole table list?
>
> We have a certain group of tables that are created on a regular basis.
Table creation on the slave node is not an issue as they are created by
triggers, but adding them to slony config seems to be an issue.
>

http://slony.info/documentation/2.2/stmtsetaddtable.html

A set of tables may be specified via a regular expression, thus:

SET ADD TABLE (
    SET ID=1,
    TABLES='public\\.tracker*'
);

The "sharp edge" to that is that if you request that repeatedly, it would
try to re-add tables already being replicated, which presumably fails.

This represents mechanism for what you asked for, all the same.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20151217/ea390600/attachment.htm 


More information about the Slony1-general mailing list