Greg Sabino Mullane greg at endpoint.com
Fri Aug 20 08:25:42 PDT 2010
> 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 


More information about the Slony1-general mailing list