<br><div class="gmail_quote">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><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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 class="HOEnZb"><font color="#888888"><br></font></span></i></font></font></i></font></font><span class="HOEnZb"><font color="#888888"><br>
Mark Steben <br> DBA at AutoRevenue </font></span></i></font></font><br><br>
<br>_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info">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.<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>