> > Slon seems to be outputting the following and doesn't seem to be
doing
> > anything else. Whats it waiting for? I've done an insert no the
master
> > and nothing seems to be coming through and I've used the same
starting
> > point as the master.
> >
> > CONFIG main: slon version 1.0.5 starting up
> > CONFIG main: local node id = 1
> > CONFIG main: loading current cluster configuration
> > CONFIG storeNode: no_id=2 no_comment='Node 2'
> > CONFIG storePath: pa_server=2 pa_client=1
> > pa_conninfo="dbname=prod_provision host=154.8.2.51 user=pgsql"
> > pa_connretry=10
> > CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
> > CONFIG storeSet: set_id=1 set_origin=1 set_comment=''
> > CONFIG main: configuration complete - starting threads
> > CONFIG enableNode: no_id=2
> 
> It seems to me that what you need to do is to progressively configure
> things, and take a look to see that each step "takes."
> 
> 1.  Create the two nodes.
> 
> 2.  Start the 2 slons.  They'll start out very quiet, like the above.

Yups I get this

> 3.  STORE PATH for the communications paths.  That should allow the
> nodes to become aware of one another.
> 
> Look at the contents of sl_path, sl_node; if there are 2 nodes, then
> you should have 2 entries in each of those tables on both nodes after
> doing the STORE PATH.  (Possibly you'll have one sl_path on each
> node.)

2 entries in sl_node and one in sl_path

> 
> 4.  STORE LISTEN to indicate how the nodes will use the paths.
> 
> After doing this, the nodes should start a greater "flood" of
activity.
> 
> Both should submit SYNC events every so often.
> 
> Look at sl_path, sl_node, sl_listen on each node.  There should be 2
> rows in each table.
> 
> If not, then communications won't be working right, and your
> efforts/questions should target fixing this.  Don't try to go on to
> later steps if the nodes aren't communicating; you would just be
> wasting your time on the wrong problem.

I'm not getting _any_ SYNC events. Which aspect of the communication?
I've tested that each node can psql to the database on the other
machine. Or does the slon use a port separate to postgres?


> I'm going to see about adding the above to the documentation section
> on monitoring; that's the first that I have tried to document the
> differences between these various "phases."

Definitely! I'm finding it very useful in tracking down what I'm doing
wrong.

Before these steps I create dbs on each node and shove a snapshot of the
schema complete with data too.

Cheers
Jase