You are using a CVS STABLE/HEAD slon process together with an older 
slony1_funcs.sql set and probably old triggers. After updating the 
installation on all nodes, execute a slonik script that uses

     "update functions"

to reload all the function and stored procedure definitions.


Jan


On 10/12/2004 12:25 PM, John Adams wrote:

> anyone know what may cause that fatal error on running
> the slon command ? 
> I am following the basic-setup, and have a one table,
> one column test case. 
> Here's a quicky of the preceding commands ...
> dropdb pp1; 
> dropdb pp2; 
> createdb pp1; 
> createdb pp2; 
> ./populate.sh; // creates and populates a one column
> table 
> createlang plpgsql pp1; 
> pg_dump -s pp1 | psql pp2;
> 
> Then I try to run "slon ppcluster2 "dbname=pp1" or the
> slave version ... both crash with:
> 
> 2004-10-12 17:53:14 PDT CONFIG main: local node id = 1
> 2004-10-12 17:53:14 PDT CONFIG main: loading current
> cluster configuration
> 2004-10-12 17:53:14 PDT CONFIG storeNode: no_id=2
> no_comment='Slave node'
> 2004-10-12 17:53:14 PDT DEBUG2 setNodeLastEvent:
> no_id=2 event_seq=0
> 2004-10-12 17:53:14 PDT CONFIG storePath: pa_server=2
> pa_client=1 pa_conninfo="dbname=pp2 host=localhost
> user=john" pa_connretry=10
> 2004-10-12 17:53:14 PDT CONFIG storeListen:
> li_origin=2 li_receiver=1 li_provider=2
> 2004-10-12 17:53:14 PDT CONFIG storeSet: set_id=1
> set_origin=1 set_comment='All pp1 tables'
> 2004-10-12 17:53:14 PDT DEBUG2 sched_wakeup_node():
> no_id=1 (0 threads + worker signaled)
> 2004-10-12 17:53:14 PDT DEBUG2 main: last local event
> sequence = 7
> 2004-10-12 17:53:14 PDT CONFIG main: configuration
> complete - starting threads
> 2004-10-12 17:53:14 PDT DEBUG1 localListenThread:
> thread starts
> 2004-10-12 17:53:14 PDT FATAL  localListenThread:
> "select "_ppcluster2".cleanupListener(); listen
> "_ppcluster2_Event"; listen "_ppcluster2_Restart"; " -
> ERROR:  function _ppcluster2.cleanuplistener() does
> not exist
> HINT:  No function matches the given name and argument
> types. You may need to add explicit type casts.
> Killed
> 
> Thanks
> 
> 
> 
> 		
> _______________________________
> Do you Yahoo!?
> Declare Yourself - Register online to vote today!
> http://vote.yahoo.com
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


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