<font size="4"><font face="courier new,monospace"><i>Sorry for redundancy: forgot to include the slony1-general list in my first response<br></i></font></font><br><div class="gmail_quote">---------- Forwarded message ----------<br>
From: <b class="gmail_sendername">Mark Steben</b> <span dir="ltr"><<a href="mailto:mark.steben@drivedominion.com">mark.steben@drivedominion.com</a>></span><br>Date: Fri, Oct 5, 2012 at 9:22 AM<br>Subject: Re: [Slony1-general] slony init_cluster problem<br>
To: Raghav <<a href="mailto:ragavendra.dba@gmail.com">ragavendra.dba@gmail.com</a>><br><br><br><font size="4"><font face="courier new,monospace"><i>First of all, I apologize for the excessive length of my first query. I'll try to keep everything short and sweet.<br>
<br>In response to Raghav's query: no slony logs have been created yet because I haven't issued<br>
a start_slon statement. Can't do that till I initialize a cluster.<br></i></font></font><font size="4"><font face="courier new,monospace"><i><font size="4"><font face="courier new,monospace"><i>Also, all the pg_logs show are the printouts of the script to create the schema. <br>
</i></font></font>Finally, check the pg_stat_activity listing I attached. <br>The CREATE table for sl_node is not in<br> a wait state.<br></i></font></font><div class="HOEnZb"><div class="h5"><br><div class="gmail_quote">
On Fri, Oct 5, 2012 at 12:54 AM, Raghav <span dir="ltr"><<a href="mailto:ragavendra.dba@gmail.com" target="_blank">ragavendra.dba@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br><div class="gmail_quote"><div><div>On Fri, Oct 5, 2012 at 1:08 AM, Mark Steben <span dir="ltr"><<a href="mailto:mark.steben@drivedominion.com" target="_blank">mark.steben@drivedominion.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>
<font size="4"><font face="courier new,monospace"><i>Hi, trying to initialize a new cluster using the alt-perl scripts provided<br> in the install<br>Here are the specs<br><br><b>MASTER: <br></b>linux installed on a VM setup.<br>
(The VM is installed on a Windows 7 OS running on a HP Elitebook laptop)<br> 8.0.4 build-744019<br> the uname -a command:<br><b>Linux localhost.localdomain 2.6.18-308.13.1.el5 #1 SMP Tue Aug 21 17:10:18 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux</b><br>
</i></font></font><font size="4"><font face="courier new,monospace"><i>total shared memory available: 2 GB<br>postgres installed: 8.3.21 (with enable_thread_safety)<br>slony installed: 2.1.1<br><br></i></font></font><i></i><br>
<font size="4"><font face="courier new,monospace"><i><b>SLAVE: <br></b>linux installed on a dell desktop<br>(The primary OS on this machine is linux)<br> the uname -a command:<br><b>Linux <a href="http://msteben-centos.autorevenue.com" target="_blank">msteben-centos.autorevenue.com</a> 2.6.1</b></i></font></font><font size="4"><font face="courier new,monospace"><i><b>8-194.11.4.el5 #1 SMP Tue Sep 21 05:04:09 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux<br>
</b></i></font></font><font size="4"><font face="courier new,monospace"><i><font size="4"><font face="courier new,monospace"><i>total shared memory available: 2 GB<br></i></font></font></i></font></font><font size="4"><font face="courier new,monospace"><i><font size="4"><font face="courier new,monospace"><i><font size="4"><font face="courier new,monospace"><i>postgres installed: 8.3.21 (with enable_thread_safety)<br>
slony installed: 2.1.1<br><br><b>PROBLEM:<br> </b>I attempt to run the altperl script ./slonik_init_cluster from the slave<br> the connection gets through to the master, but all it does on the master is <br> print the replication schema (all the sl tables) over and over and over again<br>
in the postgres logs. It never gets to creating the _reptest schema, then<br> defining the sl_tables. When I do a query on pg_stat_activity on the master<br> the one query actually running is the CREATE TABLE sl_nodes statement. It never<br>
finishes. I finally have to kill the connection and nothing gets done.<br><br> I've attached the postgresql.conf from both servers as well as the slon_tools.conf<br> from the slave. The admin user referenced in the slon_tools is slony and<br>
is defined as a superuser.<br><br> Any help appreciated. Any other info you need, please let me know.<span><font color="#888888"><br></font></span></i></font></font></i></font></font><span><font color="#888888"><br>
Mark Steben <br> DBA at AutoRevenue </font></span></i></font></font><br><br>
<br></div></div>_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br></blockquote></div><br>Before doing any guesses, slony logs(also pg_logs) would be helpful to know why exactly CREATE TABLE SL_NODE is in waiting state.<span><font color="#888888"><br clear="all"><div>
<br></div>-- <br>Regards<div>Raghav</div><div>
Blog: htt://<a href="http://raghavt.blogspot.com/" target="_blank">raghavt.blogspot.com/</a></div><br>
</font></span></blockquote></div><br><br clear="all"><br></div></div><div class="HOEnZb"><div class="h5">-- <br><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br>
Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br>
<a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br>
<span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br>
<a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br>
<br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br>
</span></span></font></span></p><font color="#888888"></font><br>
</div></div></div><br><br clear="all"><br>-- <br><div><span><font color="#888888"><span style="font-family:Calibri;font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> </span><br> Database Administrator<span style="font-family:"Century Gothic";font-size:8pt"><span style="color:rgb(51,51,51)"></span><br>
<a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autorevenue.com/" target="_blank">@utoRevenue</a> <span style="color:rgb(79,129,189);font-size:10pt">|</span> <a style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none" href="http://www.autobase.net/" target="_blank">Autobase</a> <span style="color:rgb(79,129,189);font-size:10pt"></span> <br>
<span style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none">CRM division of Dominion Dealer Solutions</span> <br><span style="color:gray;font-size:8pt">95D Ashley Ave.<br>West Springfield, MA 01089</span> <br>
<span style="color:gray;font-size:8pt">t: <a value="+14132434800">413.327-3045</a></span> <br><span style="color:gray;font-size:8pt">f: <a value="+14132434800">413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" target="_blank">www.fb.com/DominionDealerSolutions</a><br>
<a href="http://www.twitter.com/DominionDealer" target="_blank">www.twitter.com/DominionDealer</a><br><span style="color:gray;font-size:8pt"> <a href="http://www.autorevenue.com/" target="_blank">www.drivedominion.com</a><br>
<br><a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br><br></span></span></font></span><br><span><font color="#888888"><span style="font-family:"Century Gothic";font-size:8pt"><span style="color:gray;font-size:8pt"><br>
</span></span></font></span></p><font color="#888888"></font><br>