All I had to do is run separate instances of slon process for each slony
cluster.
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
**********************************************************************
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
