<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">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.<br></i></font></font></i></font></font><br>Mark Steben <br> DBA at AutoRevenue </i></font></font><br><br>