Thanks for that info. Another question:

If lots of database changes happen in "very quick" succession on the origin node, so that they are all replicated during the same SYNC, are they guaranteed to be replicated out in the true order they happened?

Cheers,
Vicki


-----Original Message-----
From: slony1-general-bounces at gborg.postgresql.org
[mailto:slony1-general-bounces at gborg.postgresql.org]On Behalf Of Tim
Goodaire
Sent: 24 June 2005 14:24
To: slony1-general at gborg.postgresql.org
Subject: Re: [Slony1-general] multiple database help


On Fri, Jun 24, 2005 at 02:15:28PM +0100, Victoria Parsons wrote:

>    I am fairly new to slony and need a quick help.

> 

>    I have my first database replicating to mulitple slaves. I now want to add

>    another database replicating with the same origin and slaves. I thought I

>    could add it as a new set (my first and only set contains all tables from

>    my first db) but I have just realised that a node is tied to a database.


Right. 


>    So my question is, should I add more nodes to the cluster with the same

>    connection hosts as the first set but the new database name, or should I

>    create a new cluster. 


You'll have to create a new cluster.


>    I assume with a new cluster I'll need to have run

>    slony twice for each host, once for each cluster.


You'll need to run a slon for each node in the two clusters.


Tim





> 

>    Thanksk for your help,

>    Vicki

> 

>    __________________________________________________

> 

>    Victoria Parsons

>    victoria.parsons at streamshield.com

> 

>    This message should be regarded as confidential. If you have received this

>    email in error please notify the sender and destroy it immediately.

>    Statements of intent shall only become binding when confirmed in hard copy

>    by an authorized signatory.

> 

> 

> 

> This message has been scanned for all known viruses and dangerous content by

> [1]StreamShield Protector, and has been found to be clean.

> 

> References

> 

>    Visible links

>    1. http://www.streamshield.com/


> _______________________________________________

> Slony1-general mailing list

> Slony1-general at gborg.postgresql.org

> http://gborg.postgresql.org/mailman/listinfo/slony1-general



-- 

Tim Goodaire    416-673-4126    tgoodair at ca.afilias.info

Database Administrator, Afilias Canada Corp.


-- 
This message has been scanned for viruses and potentially
harmful content by StreamShield Protector.