No, I haven't used it. Instead, I have created scripts for each cluster (to
create the cluster, fire off slon daemon, define and subscribe the sets - so
all necessary configurations included in the scripts).
Regards,
- Husam
-----Original Message-----
From: "Geoffrey" <[EMAIL PROTECTED]>
To: "Tomeh, Husam" <[EMAIL PROTECTED]>
Cc: "Slony List" <[email protected]>
Sent: 12/21/2007 11:00 AM
Subject: Re: [Slony1-general] questions about slon_tools.conf
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: [EMAIL PROTECTED] 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
> [email protected]
> 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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
