On 9/17/2004 11:02 AM, Vivek Khera wrote:

> I'm running the sample pgbench replication from the docs. I built Pg 
> and slony from freebsd ports. slony is 1.0.2, freebsd 4.10 with Pg 
> 7.4.5.
> 
> I'm having an issue with running the slon daemon. I got it to work on a 
> FreeBSD 5.3beta system with Pg 7.4.5 just fine. What happens on FreeBSD 
> 4.10 is when I run slon either as the client or the master it stops 
> after printing "CONFIG main: local node id = 1" or id=2 for the slave.
> 
> I turned on logging of all queries, and the only thing that slon 
> queries is this:
> 
> Sep 17 10:53:25 staging postgres[4033]: [2-1] LOG:  duration: 2.163 ms  
> statement: select last_value::int4 from 
> "_slony_example".sl_local_node_id
> 
> Then the slon process sits in a "poll" state accumulating no CPU.
> 
> Any suggestions on how to proceed?  All my production boxes are FreeBSD 
> 4.10, and I'm pretty sure Jan is using FreeBSD 4, too...

I didn't get around upgrading any of my systems to 4.10 yet ... pretty 
sure a reason to.


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 #