Skip site navigation (1) Skip section navigation (2)

Re: [Slony1-general] 2 problems

From: "Lukas" <lukas(at)fmf(dot)vtu(dot)lt>
To: "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, slony1-general(at)lists(dot)slony(dot)info
Subject: Re: [Slony1-general] 2 problems
Date: 2007-11-15 19:00:14
Message-ID: 62155.217.117.29.29.1195153214.squirrel@fmf.vtu.lt (view raw or flat)
Thread:
Lists: pgsql-novice
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.


In response to

Responses

pgsql-novice by date

Next:From: Kenneth PorterDate: 2007-11-15 19:20:26
Subject: Re: Numeric type equivalent
Previous:From: Andrew HammondDate: 2007-11-15 18:33:18
Subject: Re: [Slony1-general] 2 problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group