Thu Nov 15 11:00:14 PST 2007
- Previous message: [Slony1-general] 2 problems
- Next message: [Slony1-general] 2 problems
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello, and thanks for answer, >> on Gentoo Linux, > I don't know how you decided on Gentoo as a platform for your database. It > strikes me as a stupid choice. In two sentences, why? >> DB is replicated with Slon version 1.2.0. > Once again, bad idea. For new clusters, you should always use the latest > stable release, currently that is 1.2.12. Yes, I agree. One question: can I use different slon versions on different nodes in one replica? > > >> Fist problem started with one node, with stopped to replicate with such >> error: >> >> 2007-11-15 13:17:21 EET ERROR remoteWorkerThread_1: "insert into >> "public"."kainos" >> (paslaugos,laikai,abonimentas,kaina,pastaba,rodyti,tipas,vienkartinis,gal >> >> ioja_nuo,galioja_iki,id,pradine_imoka,intervalas,intervalas_paskutinis,imoku_skaicius,viso_sumoketi,periodine_imoka,max_pirkiniu_suma,padalinys,padaliniu_gru >> pe) values ('baseinas+treniruokliai ','Visos dienos >> ','1 m<EB>nesio ','284.00','Bendra korta >> ','t','V >> isi','f',NULL,NULL,'1110',NULL,NULL,NULL,NULL,NULL,NULL,'50.00 >> ','0','201'); >> " ERROR: insert or update on table "kainos" violates foreign key >> constraint "fk_kainos_padaliniu_grupe" >> DETAIL: Key (padaliniu_grupe)=(201) is not present in table >> "padaliniu_grupes". >> >> Note that table "kainos" and table "padaliniu_grupes" are replicated! >> only in two different sets. > > > That's probably a bad idea. Unless you have a very good reason to put them > in different sets, you should keep stuff that inter-relates together in a > single set. Are both sets subscribed on your replica? Yes, all sets are on my replica. > PostgreSQL uses unique indexes to implement primary keys. But as I > mentioned > before, making changes to your schema is probably not the right way to > solve > your problem. Yes, I agree, it just a try for work around.. Can you suggest something? Lukas -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
- Previous message: [Slony1-general] 2 problems
- Next message: [Slony1-general] 2 problems
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list