On Fri, Jan 3, 2014 at 6:42 PM, Scott Marlowe <scott.marlowe at gmail.com>wrote:

> On Fri, Jan 3, 2014 at 7:04 PM, Tory M Blue <tmblue at gmail.com> wrote:
> >
> >
> >
> > On Fri, Jan 3, 2014 at 5:45 PM, Scott Marlowe <scott.marlowe at gmail.com>
> > wrote:
> >>
> >> On Fri, Jan 3, 2014 at 6:25 PM, Tory M Blue <tmblue at gmail.com> wrote:
> >> > "Slon daemon is running on the slave not the master", ummm I'm running
> >> > the
> >> > slon daemon on all of my DB's (master/Slave, QuerySlave1, QuerySlave2)
> >> >
> >> >  slon $CLS_CLUSTER -f /data/pgsql/slon.conf  "dbname=$ADMCLSDB
> >> > user=$SUPERUSER host=$SLAVEHOST" 2>&1 > /data/logs/slon.log &
> >>
> >> I mean that the actual daemon needs to be running ON the slave node,
> >> not on the master node. Not sure if I wasn't clear, or if you weren't
> >> clear. I.e. you start the daemon on each slave, not on the master. IF
> >> that's what you're doing then just ignore this.
> >
> >
> >
> > No, I run the daemon on all nodes.  I feel I'm totally not following or
> have
> > confused myself :)
> >
> > But I run the upper command with a $MASTERHOST substitution.
>
> So on which MACHINE HOST do you run the above commands? I.e are you
> running that command x times on the master host to connect to all
> slaves, or are yuo running it once on each host for that one node.
>

Oops Sorry Scott/all, the above command is ran once on the each host, So
all hosts are running the slon Daemon.

Master Host (primary insert DB) (idb01.domain.com)

 slon $CLS_CLUSTER -f /data/pgsql/slon.conf  "dbname=$ADMCLSDB
user=$SUPERUSER host=$MASTERHOST" 2>&1 > /data/logs/slon.log &

Slave Host (secondary Insert DB) idb02.domain.com

 slon $CLS_CLUSTER -f /data/pgsql/slon.conf  "dbname=$ADMCLSDB
user=$SUPERUSER host=$SLAVEHOST" 2>&1 > /data/logs/slon.log &

Query Slave 1 (Read only query DB) qdb01.domain.com

 slon $CLS_CLUSTER -f /data/pgsql/slon.conf  "dbname=$ADMCLSDB
user=$SUPERUSER host=$QUERYHOST1" 2>&1 > /data/logs/slon.log &

Query Slave 2 (Red only query DB) qdb02.domain.com

 slon $CLS_CLUSTER -f /data/pgsql/slon.conf  "dbname=$ADMCLSDB
user=$SUPERUSER host=$QUERYHOST2" 2>&1 > /data/logs/slon.log &

Thanks
Tory
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20140103/e0e32525/attachment-0001.htm