On Fri, 2006-04-07 at 08:33, Marcin Mańk wrote: > Hello. > The general policy for slony is 'no ddl should be performed on replicated > databases'. Does this apply to temporary tables too? Can I safely create > temporary tables on the master/on the slaves ?
Slony doesn't replicate databases. It replicates data sets on databases. So, as long as what you're mucking about with isn't in the replication set, you're cool. Note that since indexes live outside of tables, it's quite possible to have a source set with the bare needed indexes for data coherency, and a subscriber with extra indexes on things like functions and such (careful with unique indexes, you can make a subscriber than can't update) that allow for fast reporting. So, temp tables are your to play with, unless you're actually somehow replicating them. Which would require more than a little effort and a fair bit of the crazy. :) _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
