<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jan 3, 2014 at 6:42 PM, Scott Marlowe <span dir="ltr"><<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">On Fri, Jan 3, 2014 at 7:04 PM, Tory M Blue <<a href="mailto:tmblue@gmail.com">tmblue@gmail.com</a>> wrote:<br>
><br>
><br>
><br>
> On Fri, Jan 3, 2014 at 5:45 PM, Scott Marlowe <<a href="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>><br>
> wrote:<br>
>><br>
>> On Fri, Jan 3, 2014 at 6:25 PM, Tory M Blue <<a href="mailto:tmblue@gmail.com">tmblue@gmail.com</a>> wrote:<br>
>> > "Slon daemon is running on the slave not the master", ummm I'm running<br>
>> > the<br>
>> > slon daemon on all of my DB's (master/Slave, QuerySlave1, QuerySlave2)<br>
>> ><br>
>> > slon $CLS_CLUSTER -f /data/pgsql/slon.conf "dbname=$ADMCLSDB<br>
>> > user=$SUPERUSER host=$SLAVEHOST" 2>&1 > /data/logs/slon.log &<br>
>><br>
>> I mean that the actual daemon needs to be running ON the slave node,<br>
>> not on the master node. Not sure if I wasn't clear, or if you weren't<br>
>> clear. I.e. you start the daemon on each slave, not on the master. IF<br>
>> that's what you're doing then just ignore this.<br>
><br>
><br>
><br>
> No, I run the daemon on all nodes. I feel I'm totally not following or have<br>
> confused myself :)<br>
><br>
> But I run the upper command with a $MASTERHOST substitution.<br>
<br>
So on which MACHINE HOST do you run the above commands? I.e are you<br>
running that command x times on the master host to connect to all<br>
slaves, or are yuo running it once on each host for that one node.<br></blockquote><div><br></div><div>Oops Sorry Scott/all, the above command is ran once on the each host, So all hosts are running the slon Daemon.</div>
<div><br></div><div>Master Host (primary insert DB) (<a href="http://idb01.domain.com">idb01.domain.com</a>)</div><div><br></div><div><div> slon $CLS_CLUSTER -f /data/pgsql/slon.conf "dbname=$ADMCLSDB user=$SUPERUSER host=$MASTERHOST" 2>&1 > /data/logs/slon.log &</div>
</div><div><br></div><div>Slave Host (secondary Insert DB) <a href="http://idb02.domain.com">idb02.domain.com</a></div><div><br></div><div><div> slon $CLS_CLUSTER -f /data/pgsql/slon.conf "dbname=$ADMCLSDB user=$SUPERUSER host=$SLAVEHOST" 2>&1 > /data/logs/slon.log &</div>
</div><div><br></div><div>Query Slave 1 (Read only query DB) <a href="http://qdb01.domain.com">qdb01.domain.com</a></div><div><br></div><div><div> slon $CLS_CLUSTER -f /data/pgsql/slon.conf "dbname=$ADMCLSDB user=$SUPERUSER host=$QUERYHOST1" 2>&1 > /data/logs/slon.log &</div>
</div><div><br></div><div>Query Slave 2 (Red only query DB) <a href="http://qdb02.domain.com">qdb02.domain.com</a></div><div><br></div><div><div> slon $CLS_CLUSTER -f /data/pgsql/slon.conf "dbname=$ADMCLSDB user=$SUPERUSER host=$QUERYHOST2" 2>&1 > /data/logs/slon.log &</div>
</div><div><br></div><div>Thanks</div><div>Tory</div><div><br></div><div><br></div><div><br></div></div></div></div>