On Fri, Oct 5, 2012 at 1:08 AM, Mark Steben <[email protected]>wrote:
> *Hi, trying to initialize a new cluster using the alt-perl scripts > provided > in the install > Here are the specs > > MASTER: > linux installed on a VM setup. > (The VM is installed on a Windows 7 OS running on a HP Elitebook laptop) > 8.0.4 build-744019 > the uname -a command: > 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 > **total shared memory available: 2 GB > postgres installed: 8.3.21 (with enable_thread_safety) > slony installed: 2.1.1 > > *** > *SLAVE: > linux installed on a dell desktop > (The primary OS on this machine is linux) > the uname -a command: > Linux msteben-centos.autorevenue.com 2.6.1**8-194.11.4.el5 #1 SMP Tue Sep > 21 05:04:09 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux > **total shared memory available: 2 GB > **postgres installed: 8.3.21 (with enable_thread_safety) > slony installed: 2.1.1 > > PROBLEM: > I attempt to run the altperl script ./slonik_init_cluster from the slave > the connection gets through to the master, but all it does on the master > is > print the replication schema (all the sl tables) over and over and over > again > in the postgres logs. It never gets to creating the _reptest schema, > then > defining the sl_tables. When I do a query on pg_stat_activity on the > master > the one query actually running is the CREATE TABLE sl_nodes statement. > It never > finishes. I finally have to kill the connection and nothing gets done. > > I've attached the postgresql.conf from both servers as well as the > slon_tools.conf > from the slave. The admin user referenced in the slon_tools is slony and > is defined as a superuser. > > Any help appreciated. Any other info you need, please let me know. > > Mark Steben > DBA at AutoRevenue * > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > > Before doing any guesses, slony logs(also pg_logs) would be helpful to know why exactly CREATE TABLE SL_NODE is in waiting state. -- Regards Raghav Blog: htt://raghavt.blogspot.com/
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
