Tue Oct 26 03:12:28 PDT 2010
- Previous message: [Slony1-general] VMWARE question
- Next message: [Slony1-general] reintegrating a failed master
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello, I installed slony 2.0.4 and postgres 8.4 on Red Hat system and setup-up a Slony cluster with 3 nodes, lets call them n1,n2 and n3. Normal replication and switch over are working fine. If the master n1 fails, then I do a failover on n2 and n3 and for them life go's on. My troubles starts if I try to reintegrate n1 as slave, on startup everything looks fine, than I subscribe him new for n2 which also looks fine. "subscribe set ( id = 1, provider = 2, receiver = 1, forward = yes);" But when new set arrives at n1 I get following failure. "select "_smv_ts_rep".setAddTable_int(1, 1, '"public"."role"', 'role_pkey', 'role table'); " PGRES_FATAL_ERROR FEHLER: Slony-I: setAddTable_int: table id 1 has already been assigned!" A "REPAIR CONFIG ( SET ID = 1, EVENT NODE = 2);" had no effect on this issue. I guess it is just a small thing which slipped my attention, but I'm very gratefully for every advise in this situation. Greetings Ole
- Previous message: [Slony1-general] VMWARE question
- Next message: [Slony1-general] reintegrating a failed master
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list