Ah!, thanks,  that was the problem.  I was not using unique ids.

-----Original Message-----
From: Mikko Partio [mailto:mpartio at gmail.com]
Sent: Friday, September 21, 2007 11:09 PM
To: Daniel B. Thurman
Cc: Slony-I (E-mail)
Subject: Re: [Slony1-general] Problems with replication




On 9/21/07, Daniel B. Thurman < HYPERLINK "mailto:dant at cdkkt.com"dant at cdkkt=
.com> wrote: =



On the master server, I have an error reported:
ERROR  remoteWorkerThread_2: "select "_MasterCluster".setAddTable_int(1, 1,=
 '"public"."cars"', 'cars_pkey', ''); " PGRES_FATAL_ERROR ERROR:  Slony-I: =
setAddTable_int: table id 1 has already been assigned! =


On the slave server, I have an error reported:
ERROR  remoteWorkerThread_1: "select "_MasterCluster".setAddTable_int(1, 1,=
 '"public"."cars"', 'cars_pkey', ''); " PGRES_FATAL_ERROR ERROR:  Slony-I: =
setAddTable_int: table id 1 has already been assigned! =


What does this mean, and what do I need to do to fix this?

Thanks!
Dan


Well I'd decipher this mystical error report so that you already have a tab=
le in replication with id 1 and now you're trying to add another one with t=
he same id and obviously that won't work. Table id's have to unique in a re=
plication cluster (if I remember correctly), so just use id=3D2 for example=
. =


Regards

MP =






No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.487 / Virus Database: 269.13.27/1020 - Release Date: 9/20/2007=
 12:07 PM



No virus found in this outgoing message.
Checked by AVG Free Edition. =

Version: 7.5.487 / Virus Database: 269.13.27/1020 - Release Date: 9/20/2007=
 12:07 PM
 =

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070922/=
86b3ffa3/attachment.htm