Thanks for the quick response. Yes, you are right function getLocalNodeId does not exist on subscriber node but it does exists on primary node. On further check I could see on primary node under replication schema total 127 functions but in subscriber node I could see only 112. Not sure why there are missing functions which include getLocalNodeId.

This is the very first time I am trying to set up slony replication. I am following documentation on slony.info.

Thanks again.
Samir

-----Original Message-----
From: Glyn Astill [mailto:glynastill at yahoo.co.uk] 
Sent: Thursday, April 17, 2014 2:20 AM
To: Samir Parikh; slony1-general at lists.slony.info
Subject: Re: [Slony1-general] Slony setup error

> 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?