Tue Jun 26 13:48:01 PDT 2012
- Previous message: [Slony1-general] Change encoding
- Next message: [Slony1-general] Restart Nodes
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All, I want to restart two nodes after a switchover. The thing is that I make switchover and then I switch the IP of both nodes. And when that occurs, both nodes stop listening each other. So, what I thought is restart the nodes, so then they can start listening again. This is part of the code: node 1 admin conninfo = 'dbname=$db_one_name port=$db_one_port host=$db_one_host user=$user'; node 2 admin conninfo = 'dbname=$db_two_name port=$db_two_port host=$db_two_host user=$user'; echo 'Restarting first node'; restart node 1; wait for event (origin=1, confirmed=2, wait on=1); echo 'Node restarted'; echo 'Restarting second node'; restart node 2; wait for event (origin=2, confirmed=1, wait on=2); echo 'Node restarted'; When it's executed, all seems to be okay, but when I try to see the lag time this is what I get: postgres=# select st_origin, st_received, st_lag_time from _slony_replication.sl_status; st_origin | st_received | st_lag_time -----------+-------------+----------------- 2 | 1 | 00:08:20.927686 (1 row) And 8 minutes passed since the IP were switched. Am I doing something wrong? Sorry for my bad english. Thanks, Diego -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20120626/7e401aef/attachment.htm
- Previous message: [Slony1-general] Change encoding
- Next message: [Slony1-general] Restart Nodes
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list