<html>
<head>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-15">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font size="-1">Hi All,<br>
<br>
I want to restart two nodes after a switchover.<br>
The thing is that I make switchover and then I switch the IP of
both nodes.<br>
And when that occurs, both nodes stop listening each other.<br>
So, what I thought is restart the nodes, so then they can start
listening again.<br>
This is part of the code:<br>
<br>
</font><big><font size="-1"><big><tt> node 1 admin conninfo =
'dbname=$db_one_name port=$db_one_port host=$db_one_host
user=$user';<br>
node 2 admin conninfo = 'dbname=$db_two_name
port=$db_two_port host=$db_two_host user=$user';<br>
echo 'Restarting first node';<br>
restart node 1;<br>
wait for event (origin=1, confirmed=2, wait on=1);<br>
echo 'Node restarted';<br>
echo 'Restarting second node';<br>
restart node 2;<br>
wait for event (origin=2, confirmed=1, wait on=2);<br>
echo 'Node restarted';</tt></big></font></big><font
size="-1"><br>
<br>
When it's executed, all seems to be okay, but when I try to see
the lag time this is what I get:<br>
<br>
</font><big><font size="-1"><big><tt>postgres=# select st_origin,
st_received, st_lag_time from _slony_replication.sl_status;<br>
st_origin | st_received | st_lag_time <br>
-----------+-------------+-----------------<br>
2 | 1 | 00:08:20.927686<br>
(1 row)</tt></big></font></big><font size="-1"><br>
<br>
And 8 minutes passed since the IP were switched.<br>
<br>
Am I doing something wrong?<br>
<br>
Sorry for my bad english.<br>
Thanks,<br>
Diego<br>
</font> <br>
</body>
</html>