From: | "tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | "Ashish Sharma" <ashish(dot)sharma(at)globallogic(dot)com>, "Gaurav Katiyar" <gaurav(dot)katiyar(at)globallogic(dot)com> |
Subject: | "duplicate key violates unique constraint" error |
Date: | 2009-11-12 05:12:35 |
Message-ID: | 68666423656E1444A011106C4E085F4DA88E1D@ex3-del1.synapse.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All
I have a cluster setup with one master and one slave . Replication from
master to slave is not taking place.
I am getting this error "duplicate key violates unique constraint" in
my slon.log on slave . This error is thrown while
Slon is inserting a row in a table on slave. This must be because of
the reason that duplicate rows
are being returned while querying sl_log_1 table. I googled about the
same problem and found that
there is some bug in postgres due to which some table or index on that
table gets corrupted. Due to this
duplicate rows are either stored in the table or there are no duplicate
rows but
duplicates are returned while querying the table.
I am using postgres 8.1.2 and slony 1.1.5 .
Please suggest which version of postgres has fix for above mentioned
problem.
Thanks...
Tamanna
From | Date | Subject | |
---|---|---|---|
Next Message | Mikko Partio | 2009-11-12 05:50:06 | Re: Postgres Clustering Options |
Previous Message | Peter Geoghegan | 2009-11-12 00:32:52 | Re: [GENERAL] pgday.eu |