"Stéphane A. Schildknecht" stephane.schildknecht at postgresqlfr.org
Mon Jul 28 01:35:59 PDT 2008
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

lai at clustersolutions.net a écrit :
> Hello, I have a production cluster of node a and node b where node a is
> the master and node b is the slave. Node a at this time is replicating
> table x in set 1 to node b. My question is is there a problem where I
> would create a set 2 and name node b as the origin and have table y
> replicating to node a? Have anyone done this before?
> 
> NODE A             NODE B
> table x ------> table x (set1)
> table y <------ table y (set2)
> 
> Thank you ahead for your help!
> 
> Regards,
> 
> Tim

One of the main Slony features is to allow cross replication.

So, be sure there is no problem in creating a second set and cross replicate
between node a (set1) and node b (set2).

Oh, and yes, I've done it, and it does work :-)

Regards,
- --
Stéphane Schildknecht
PostgreSQLFr : http://www.postgresql.fr

Venez nous rencontrer le 4 octobre lors du plus important événement
PostgreSQL francophone : http://www.pgday.fr

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIjYTvA+REPKWGI0ERAlcZAKDSBc4vG2wBgkl35yPkXzppEmMizQCgpkWP
GrWhw8Obe4wQF9+R8o2sT0g=
=gend
-----END PGP SIGNATURE-----


More information about the Slony1-general mailing list