Fri Sep 21 23:09:14 PDT 2007
- Previous message: [Slony1-general] Problems with replication
- Next message: [Slony1-general] [SOLVED] Problems connecting via slon service
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On 9/21/07, Daniel B. Thurman <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 table in replication with id 1 and now you're trying to add another one with the same id and obviously that won't work. Table id's have to unique in a replication cluster (if I remember correctly), so just use id=3D2 for examp= le. Regards MP -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070922/= bf8b7e59/attachment-0001.htm
- Previous message: [Slony1-general] Problems with replication
- Next message: [Slony1-general] [SOLVED] Problems connecting via slon service
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list