> 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
