Hi Steve,<div><br></div><div>I have placed a script in the /etc/init.d folder of my debian machine which has the commands as</div><div><br></div><div>#!/bin/sh</div><div>bash -u postgres -c '/usr/lib/postgresql/8.4/bin/pg_ctl start -D /var/lib/postgresql/8.4/main" '<br>
</div><div>bash -u postgres -c '/usr/bin/slon conninfo= "dbname=testdb user=postgres" '<br><br></div><div>I have configured this script on each of the 4 machines to run at the the reboot time which will start the database and then will run the slon process. I am passing conninfo on the command line itself and before doing the reboot, i have also made the cluster_setup and subscriptions for the four nodes. So its like replication is going on when i do reboot on one of the machines. </div>
<div><br></div><div>As you pointed out, this all procedure works fine in 2.0.7, but fails in the version 2.0.4. Also while seeing the output of the <b>ps aux | grep postgres</b> command at the times of broken and not-broken connection, i can see the entries for the processes related to database of the other machines (which are connected to it as described in subscription script) in the not-broken connection whereas broken connection (after reboot) has only local database entries in the command output.</div>
<div><br></div><div>Thanks for helping me out. :)</div><div><br></div><div>Regards</div><div>Dilraj Singh</div><div><br><div class="gmail_quote">On Mon, Aug 8, 2011 at 5:08 PM, Steve Singer <span dir="ltr"><<a href="mailto:ssinger_pg@sympatico.ca">ssinger_pg@sympatico.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">Once your network and postgresql instances are up you should just be able to restart all of your slon processes and replication should resume (with 2.0.4) it should recover from the dropped connections when slon is restarting.</div>
<br>
How are you starting slon? Are you using a slon.conf file or passing the conninfo on the command line? (you need to be doing one of the two).<br><font color="#888888">
<br>
Steve</font><div><div></div><div class="h5"><br></div></div></blockquote></div></div>