David Sainty David.Sainty
Mon Oct 18 23:27:56 PDT 2004
Hi all,

I've been attempting to trial Slony-I (1.0.2) as a possible
production DR replication solution, but I've had quite a bit of
difficulty getting stable results.

Running against PostgreSQL 7.4.5, I got the
"slony-I-basic-mstr-slv.txt" to partly work, but it appeared to
get stuck half-way and I didn't get all data replicated.

Theorising that it may be a library threading issue (as
mentioned on http://slony.info/), I reverted to 7.4.2 and applied
the patch.  But I've also had difficulty there (though I have
also deviated from the instructions, so that may be user error).

Perhaps I'll start there.  I can't find any mention of whether
Slony-I works with 7.4.5 unpatched in the documentation, and
while some of the threadsafe-libpq-742.diff patch seems to be
applied in 7.4.5 it doesn't look like all of it has been.

(We need to make a decision soon on using Slony.  I have
eRServer working, but I get the feeling eRServer is not really a
living project, so I'd rather get good results with Slony!)

Thanks,

Dave



More information about the Slony1-general mailing list