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());


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20141014/4b956d23/attachment.htm