> From: Granthana Biswas <granthana.biswas at gmail.com>
>To: "slony1-general at lists.slony.info" <slony1-general at lists.slony.info> 
>Sent: Tuesday, 14 October 2014, 11:15
>Subject: [Slony1-general] Changing master node's IP & port
> 
>
>
>Hi All,
>
>
>I am trying to change the master node's IP and port
>
>After stopping the slon process, I ran store path as follows:
>
>store path (server = 1, client = 2, conninfo='host=new_ip dbname=$DB1 user=$USER1 port=$PORT1');
>store path (server = 1, client = 3, conninfo='host=new_ip dbname=$DB1 user=$USER1 port=$PORT1');
>
>
>But on trying to start slon process again after changing the node config, I got the following error:
>
>nohup /usr/bin/slon -d 2 -p /var/run/slony1/cl1node1.pid -f /home/postgres/slony_test/cl1_node1.conf > /home/postgres/slony_test/log/cl1node1.log 2>&1 &
>[1] 5626
>postgres at GB:~/slony_test$ 2014-10-14 13:09:13 IST ERROR:  duplicate key value violates unique constraint "sl_nodelock-pkey"
>2014-10-14 13:09:13 IST DETAIL:  Key (nl_nodeid, nl_conncnt)=(1, 0) already exists.
>2014-10-14
13:09:13 IST STATEMENT:  select "_Cluster1".cleanupNodelock(); insert 
into "_Cluster1".sl_nodelock values (    1, 0, 
"pg_catalog".pg_backend_pid()); 
>
>

Hi Granthana,

Are you sure you'd stopped all the slons?  A quick "ps aux | grep slon" on each machine where you have slons running should be enough to check.

As long as you're positive you've stopped all the slon processes, you could clean up sl_nodelock by just doing DELETE FROM "_Cluster1".sl_nodelock WHERE nl_nodeid = 1 AND nl_conncnt = 0;



>I even tried the drop path but it gives the following error:
>
>sh drop_path.sh 
>2014-10-14 13:52:06 IST ERROR:  Slony-I: Path cannot be dropped, subscription of set 1 needs it
>2014-10-14 13:52:06 IST STATEMENT:  lock table "_Cluster1".sl_event_lock, "_Cluster1".sl_config_lock;select "_Cluster1".dropPath(1, 2); 
><stdin>:8: PGRES_FATAL_ERROR lock table "_Cluster1".sl_event_lock, "_Cluster1".sl_config_lock;select "_Cluster1".dropPath(1, 2);  - ERROR:  Slony-I: Path cannot be dropped, subscription of set 1 needs it
>
>
>Did anyone face the same issue when trying to change ip of a node? In my case, I am trying to change IP of master node.
>
>
>
>Regards,
>Granthana
>_______________________________________________
>Slony1-general mailing list
>Slony1-general at lists.slony.info
>http://lists.slony.info/mailman/listinfo/slony1-general
>
>
>