Fri Aug 20 08:25:42 PDT 2010
- Previous message: [Slony1-general] Replicate to different table name
- Next message: [Slony1-general] sl_nodelock worries
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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 greg at endpoint.com End Point Corporation PGP Key: 0x14964AC8 -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 163 bytes Desc: not available Url : http://lists.slony.info/pipermail/slony1-general/attachments/20100820/3f792ad6/attachment.pgp
- Previous message: [Slony1-general] Replicate to different table name
- Next message: [Slony1-general] sl_nodelock worries
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list