> From: Samir Parikh <SParikh at CarCharging.com>

>To: "slony1-general at lists.slony.info" <slony1-general at lists.slony.info> 
>Sent: Thursday, 17 April 2014, 2:06
>Subject: [Slony1-general] Slony setup error
>
> 
>I am getting following error while trying to set up replication ? Can somebody help ?
> 
>./slonik_subscribe_set 1 2 | ./slonik
><stdin>:5: PGRES_FATAL_ERROR select max(ev_seqno) FROM "_replication".sl_event , "_replication".sl_node  where ev_origin="_replication".getLocalNodeId('_replication')  AND ev_type <> 'SYNC'  AND sl_node.no_id= ev_origin - ERROR:  function _replication.getlocalnodeid(unknown) does not exist
>LINE 1: ...l_event , "_replication".sl_node  where ev_origin="_replicat...
>                                                             ^
>HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
>error: unable to query event history on node 2


Well have you checked to see if the "_replication" schema and getlocalnodeid function are present on your new subscriber?

From the error message I can only assume you've not run "STORE NODE" against the node you're trying to subscribe,


>waiting for events  (2,221473472232) only at (2,0) to be confirmed on node 1 


This reinforces my thoughts, as well as running STORE NODE/PATH for your new subscriber you need to make sure you have a slon running against it too.

Perhaps you could fill us in on the steps you've taken so far so we can see where you've gone off course.


Glyn.

p.s. I'll use this as a test to see if I can still post to the list from my yahoo.com address too; I've not much hope it will :-(