> I'm new to slony and have a need that I can't find answer to if it's > possible. ... > Can I change the destination table name for replication with slony? > In that the table "logs" are replicated to "logs_prodX" for each product > database. > > from (server1) logdb.logs to logdb.logs_prod1 > from (server2) logdb.logs to logdb.logs_prod2 > from (server3) logdb.logs to logdb.logs_prod3
Not possible. What you could do it create table logdb.logs_prod1 on server1, and then wrap it in a view named logdb.logs. Slony would see the underlying logs_prod1 table, but everyone else would simply see the view (with rules as needed if you want to insert without worrying about the real name) -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
pgpvLK6fBcTlR.pgp
Description: PGP signature
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
