Tue Aug 5 23:16:55 PDT 2008
- Previous message: [Slony1-general] Strange behavior adding a new node, very, VERY slow
- Next message: [Slony1-general] Strange behavior adding a new node, very, VERY slow
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 > > >
- Previous message: [Slony1-general] Strange behavior adding a new node, very, VERY slow
- Next message: [Slony1-general] Strange behavior adding a new node, very, VERY slow
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list