Martin Eriksson m.eriksson at albourne.com
Tue Aug 5 23:16:55 PDT 2008
Thanks to everyone that been helping.

Figured it out.

basically I screwed up.... there was a ip typo in my slon_tools.conf and 
it went to a completely different database server (where it just happen 
to be sitting a db with a correct schema, just that this database was 
far away and hence very very slow)

so from the master it looked like it went to the correct machine, but it 
just went to the daemon and then the daemon was passing it on to the 
other db.. so a bit of a screw up.. took a while to figure that one out, 
as often tend to overlook the most basic stuff!!

doh!

cheers
Martin

Hannu Krosing wrote:
> On Tue, 2008-08-05 at 11:31 +0300, Martin Eriksson wrote:
>   
>> this is where it start getting weird,
>>
>> No error anywhere in any log.
>>
>> with
>>
>> pg_stat_activity
>>
>> I just got 3 transactions sitting in idle (to the three other nodes, 
>> Master, node2,3)
>>
>> It is using exactly the same schema as i was using for node 2 (as its on 
>> the same machine so used the same one!)
>>     
>
> Did you by accident include existing slony schema in your copy ?
>
> -----------------
> Hannu
>
>
>   



More information about the Slony1-general mailing list