*Sorry for redundancy: forgot to include the slony1-general list in my
first response
*
---------- Forwarded message ----------
From: Mark Steben <[email protected]>
Date: Fri, Oct 5, 2012 at 9:22 AM
Subject: Re: [Slony1-general] slony init_cluster problem
To: Raghav <[email protected]>
*First of all, I apologize for the excessive length of my first query.
I'll try to keep everything short and sweet.
In response to Raghav's query: no slony logs have been created yet because
I haven't issued
a start_slon statement. Can't do that till I initialize a cluster.
**Also, all the pg_logs show are the printouts of the script to create the
schema.
Finally, check the pg_stat_activity listing I attached.
The CREATE table for sl_node is not in
a wait state.
*
On Fri, Oct 5, 2012 at 12:54 AM, Raghav <[email protected]> wrote:
>
> 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/
>
>
--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>
<http://autobasedigital.net/marketing/DD12_sig.jpg>
--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>
<http://autobasedigital.net/marketing/DD12_sig.jpg>
-[ RECORD 2
]-+--------------------------------------------------------------------------------------------------
datid | 469329490
datname | slonytst
procpid | 6042
usesysid | 16385
usename | slony
current_query | --
----------------------------------------------------------------------
: -- slony1_base.sql
: --
: -- Declaration of the basic replication schema.
: --
: -- Copyright (c) 2003-2009, PostgreSQL Global Development
Group
: -- Author: Jan Wieck, Afilias USA INC.
: --
: --
: --
----------------------------------------------------------------------
:
:
: --
**********************************************************************
: -- * Tables
: --
**********************************************************************
:
:
: --
----------------------------------------------------------------------
: -- TABLE sl_node
: --
----------------------------------------------------------------------
: create table "_reptest".sl_node (
: no_id int4,
: no_active bool,
: no_comment text,
: CONSTRAINT "sl_node-pkey"
: PRIMARY KEY (no_id)
: ) WITHOUT OIDS;
: comment on table "_reptest".sl_node is 'Holds the list of nodes
associated with this namespace.';
: comment on column "_reptest".sl_node.no_id is 'The unique ID
number for the node';
: comment on column "_rep
waiting | f
xact_start | 2012-10-05 09:05:36.20057-04
query_start | 2012-10-05 09:05:36.446774-04
backend_start | 2012-10-05 09:05:35.990462-04
client_addr | 10.10.4.34
client_port | 35521
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
