Thu Dec 17 13:21:15 PST 2015
- Previous message: [Slony1-general] Wildcards in table specification?
- Next message: [Slony1-general] Data in sl_log table that was not replicated,
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Wildcards in table specification?
- Next message: [Slony1-general] Data in sl_log table that was not replicated,
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list