<div dir="ltr"><div><div><div><div>Hi All,<br><br></div><div>I am trying to change the master node's IP and port</div><div><br></div>After stopping the slon process, I ran store path as follows:<br><br>store path (server = 1, client = 2, conninfo='host=new_ip dbname=$DB1 user=$USER1 port=$PORT1');<br>store path (server = 1, client = 3, conninfo='host=new_ip dbname=$DB1 user=$USER1 port=$PORT1');<br><br><br></div>But on trying to start slon process again after changing the node config, I got the following error:<br><br>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 &<br>[1] 5626<br>postgres@GB:~/slony_test$ 2014-10-14 13:09:13 IST ERROR: duplicate key value violates unique constraint "sl_nodelock-pkey"<br>2014-10-14 13:09:13 IST DETAIL: Key (nl_nodeid, nl_conncnt)=(1, 0) already exists.<br>2014-10-14
13:09:13 IST STATEMENT: select "_Cluster1".cleanupNodelock(); insert
into "_Cluster1".sl_nodelock values ( 1, 0,
"pg_catalog".pg_backend_pid()); <br><br><br></div>I even tried the drop path but it gives the following error:<br><br>sh drop_path.sh <br>2014-10-14 13:52:06 IST ERROR: Slony-I: Path cannot be dropped, subscription of set 1 needs it<br>2014-10-14 13:52:06 IST STATEMENT: lock table "_Cluster1".sl_event_lock, "_Cluster1".sl_config_lock;select "_Cluster1".dropPath(1, 2); <br><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<br><br><br></div>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.<br><div><br></div><div>Regards,</div><div>Granthana</div></div>