Wed Aug 5 01:08:45 PDT 2009
- Previous message: [Slony1-general] Windows Event Log Error
- Next message: [Slony1-general] Cluster setup bash script for multi-slave envrionment
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All, I am trying to replicate DB in Windows VISTA using PgadminIII, Postgres 8.3.7 and Slony 1.2.16. I am not using Slonik scripts. Although the tables in my replication set have unique ids, when i start the service for replication, slony-I tries to execute the command - select "_M_Cluster".setAddTable_int(1, 1, '"nlp_schema"."authority"', 'authority_pkey', ''); in the console and return with this error given below. 2009-08-04 10:45:53 GMT Daylight Time ERROR remoteWorkerThread_1:"select "_M_Cluster".setAddTable_int(1, 1, '"nlp_schema"."authority"', 'authority_pkey', ''); " PGRES_FATAL_ERROR ERROR:Slony-I: setAddTable_int: table id 1 has already been assigned! I tried searching for the same error in slony-I documentation which says that this error can Occur if the primary key are not been defined as NOT NULL which I have. Please let me know how to resolve this issue. Regards, Don Intelligent Addressing Ltd. Registered Office: 1 Adam Street, London WC2N 6DD Reg. in England No.3863861 VAT No.GB 802258946 This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com
- Previous message: [Slony1-general] Windows Event Log Error
- Next message: [Slony1-general] Cluster setup bash script for multi-slave envrionment
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list