Tue Dec 4 11:43:20 PST 2007
- Previous message: [Slony1-general] Renumbering a node and renaming a database
- Next message: [Slony1-general] Dropped a node and still has status
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, I've correctly dropped my node2 (still have node1 which is the set1 origin and node3 which is a slave) using this command: slonik_drop_node node2 | slonik The documentation says that this would try to kill the running slon for that node but it didn't. Could it be because postgres is running with user postgres and the slons are running as root? It correctly dropped the node because it's not listed anymore on the origins sl_node, sl_subscribe ad sl_path tables. But it's still is listed when I ask for replication status on sl_status: # SELECT * from _replication.sl_status ; st_origin | st_received | st_last_event | st_last_event_ts | st_last_received | st_last_received_ts | st_last_received_event_ts | st_lag_num_events | st_lag_time -----------+-------------+---------------+----------------------------+------------------+----------------------------+----------------------------+-------------------+----------------- 1 | 2 | 34498 | 2007-12-04 13:36:29.145529 | 34422 | 2007-12-04 13:23:46.859689 | 2007-12-04 13:23:46.835432 | 76 | 00:12:48.167806 1 | 3 | 34498 | 2007-12-04 13:36:29.145529 | 34497 | 2007-12-04 13:36:23.466897 | 2007-12-04 13:36:19.108237 | 1 | 00:00:15.895001 (2 rows) Is this going to be a problem if I create a new node and assign it number 2? Will slony think it's the old node2 coming back again and just try to sync those 76 unsynced events? Thank you -- Diego Algorta Casamayou http://www.oboxodo.com - http://diego.algorta.net
- Previous message: [Slony1-general] Renumbering a node and renaming a database
- Next message: [Slony1-general] Dropped a node and still has status
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list