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
>> 2007-11-15 13:17:21 EET ERROR remoteWorkerThread_1: "insert into
>> pe) values ('baseinas+treniruokliai ','Visos dienos
>> ','1 m<EB>nesio ','284.00','Bendra korta
>> " 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
>> 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
> before, making changes to your schema is probably not the right way to
> your problem.
Yes, I agree, it just a try for work around.. Can you suggest something?
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
In response to
pgsql-novice by date
|Next:||From: Kenneth Porter||Date: 2007-11-15 19:20:26|
|Subject: Re: Numeric type equivalent|
|Previous:||From: Andrew Hammond||Date: 2007-11-15 18:33:18|
|Subject: Re: [Slony1-general] 2 problems|