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:[email protected]] Sent: Thursday, April 17, 2014 2:20 AM To: Samir Parikh; [email protected] Subject: Re: [Slony1-general] Slony setup error > From: Samir Parikh <[email protected]> >To: "[email protected]" <[email protected]> >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 :-( _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
