On Wed, Nov 03, 2004 at 05:41:48PM +0100, J?r?mie LOPEZ wrote:
> What is the best perspective concerning several replications running on
> shared machines?
> 
> Let's consider I have - for the same project - 2 PostgreSQL servers (on 2
> distinct machines): I want the server 1 to be the master for database A and
> the slave for database B, and the server 2 to be the master for database B
> and the slave for database A.
> 
> What does follow the "slony way" the most between :
> - defining two clusters (one for each database to replicate) with 2 nodes
> each,
> - defining a unique clusters with 4 nodes (and making the correct
> subscriptions)?
>

I think you have to setup 2 clusters (and end up running 4 slon's) , because
the cluster schema itself goes into the database where the replicated data
comes from.  You can't talk to 2 databases from the same connection.
 

-- 
How many of you believe in telekinesis? Raise my hand...