All I had to do is run separate instances of slon process for each slony cl=
uster. =

 =

Regards,
 =

       -  Husam

________________________________

From: slony1-general-bounces at lists.slony.info on behalf of Geoffrey
Sent: Thu 12/20/2007 6:50 PM
To: Slony List
Subject: Re: [Slony1-general] questions about slon_tools.conf



Vivek Khera wrote:
>
> On Dec 19, 2007, at 6:12 PM, Geoffrey wrote:
>
>> As I understand it, if I'm replicating from one machine to another, I
>> must have identical slon_tools.conf files on both machines.
>
> no, you need to change teh connection string so each slon connects to
> its own server it is responsible for.
>
> the slons can run on any box; they just connect as clients to postgres. =

> most people tend to run the associated slon on the same box as the
> postgres server.

Thanks for the response.  Any ideas on the other part of my post?  That
is, how do I configure slony to handle multiple databases on one machine
to be replicated to multiple instances on a second machine?

We have eleven postmasters running on one machine in order to be able to
better control the configuration of each and limit downtime.  What I
need to do is replicate all eleven to another machine.

The example slon_tools.conf file does not appear to lend itself to this.
  There is one MASTERNODE, whereas I need eleven.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin
_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general




**********************************************************************
This message contains confidential information intended only for the use of=
 the addressee(s) named above and may contain information that is legally p=
rivileged.  If you are not the addressee, or the person responsible for del=
ivering it to the addressee, you are hereby notified that reading, dissemin=
ating, distributing or copying this message is strictly prohibited.  If you=
 have received this message by mistake, please immediately notify us by rep=
lying to the message and delete the original message immediately thereafter.

Thank you.

                                   FADLD Tag
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071221/=
842ce20e/attachment-0001.htm