Geoffrey lists at serioustechnology.com
Fri Dec 21 10:59:27 PST 2007
Tomeh, Husam wrote:
> All I had to do is run separate instances of slon process for each slony cluster. 

Are you using the slon_tools.conf file?  As I see it, it only has the 
ability to deal with one cluster at a time.

>  
> 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 privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.
> 
> Thank you.
> 
>                                    FADLD Tag
> **********************************************************************
> 


-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin


More information about the Slony1-general mailing list