On 7/16/2004 4:55 PM, Christopher Browne wrote:

> Thomas F.O'Connell <tfo at sitening.com> writes:
>> In the README and in the docs, there are basically a pair of scripts:
>> one for setup and one for subscription. What is unclear (to me) is on
>> which nodes the scripts themselves need to be run.
>>
>> Once the daemon is running on both a master and a slave node, does it
>> matter which node actually runs the setup and subscription scripts?
>>
>> Thanks!
> 
> I think you're confusing here:
>  - Where do I run slonik, which talks to database instances, and
>    tells them how to control what's going on?
> 
>    Slonik should be able to run anywhere that can talk to one or more
>    of the DBs; it initiates connections to the databases based on the
>    conninfo strings you pass in.

Slonik should run on a system that can connect to all the databases in 
the replication group/cluster. It depends on the command to which of 
them slonik actually connects to execute the command.

> 
>  - Where do I run slon, which is the daemon that controls a particular
>    replication instance?
> 
>    The initial assumption was that that should run on the DB server.

The database specified in the conninfo string on slon's commandline, 
also referred to as "local node", should be nearby and reachable via a 
reliable, fast, low-latency connection.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #