Fri Jan 11 01:27:54 PST 2008
- Previous message: [Slony1-general] Query about Slony-i from Colombia
- Next message: [Slony1-general] Query about Slony-i from Colombia
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, Thank you very much Mr. Browne for answering me back, I changed the script to this, cluster name=3DCluster_10; init cluster (id=3D1, comment=3D'Nodo maestro'); create set (id=3D1, origin=3D1, comment=3D'aqui van todas mis tablas'); set add table (set id=3D1, origin=3D1, id=3D1, fully qualified name=3D' public.Personas', comment=3D'tabla de Personas del Cluster_1'); #set add table (set id=3D1, origin=3D1, id=3D2, fully qualified name=3D' public.Personas', comment=3D'tabla de Personas del Cluster_2'); #set add table (set id=3D1, origin=3D1, id=3D3, fully qualified name=3D' public.Personas', comment=3D'tabla de Personas del Cluster_3'); store node (id=3D2, comment=3D'Nodo esclavo Cluster_2'); store node (id=3D3, comment=3D'Nodo esclavo Cluster_3'); store path (server=3D1, client=3D2, conninfo=3D'dbname=3DDB_Cluster_1 host=3D127.0.0.1user=3Droot password=3Droot port=3D5435'); store path (server=3D1, client=3D3, conninfo=3D'dbname=3DDB_Cluster_1 host=3D127.0.0.1user=3Droot password=3Droot port=3D5435'); store path (server=3D2, client=3D1, conninfo=3D'dbname=3DDB_Cluster_2 host=3D127.0.0.1user=3Droot password=3Droot port=3D5436'); store path (server=3D2, client=3D3, conninfo=3D'dbname=3DDB_Cluster_2 host=3D127.0.0.1user=3Droot password=3Droot port=3D5436'); store path (server=3D3, client=3D1, conninfo=3D'dbname=3DDB_Cluster_3 host=3D127.0.0.1user=3Droot password=3Droot port=3D5437'); store path (server=3D3, client=3D2, conninfo=3D'dbname=3DDB_Cluster_3 host=3D127.0.0.1user=3Droot password=3Droot port=3D5437'); store listen (origin=3D1, provider=3D1, receiver=3D2); store listen (origin=3D1, provider=3D1, receiver=3D3); store listen (origin=3D2, provider=3D2, receiver=3D1); store listen (origin=3D2, provider=3D2, receiver=3D3); store listen (origin=3D3, provider=3D3, receiver=3D1); store listen (origin=3D3, provider=3D3, receiver=3D2); but even so now I get a new error message C:\Archivos de programa\PostgreSQL\8.2\bin>slonik config.conf config.conf:36: PGRES_FATAL_ERROR select "_Cluster_14".determineIdxnameUnique('public.Personas', NULL); - ERROR: Slony-I: determineIdxnameUnique(): table " public"."Personas" not found So I look out in google and put "Slony-I: determineIdxnameUnique():", and found this < http://linuxfinances.info/info/function.determineidxnameunique-text-name.ht= ml> , FUNCTION determineIdxnameUnique (tab_fqname, indexname) Given a tablename, tab_fqname, check that the unique index, indexname, exists or return the primary key index name for the table. If there is no unique index, it raises an exception. I am not sure of which index key does it talk, if it is of the databases form the clusters, all of them have their owns, I will add to this post the databases (all of them =96DB_Cluster_1, DB_Cluster_2 and DB_Cluster_3- has = the same) struct -- Table: "Personas" -- DROP TABLE "Personas"; CREATE TABLE "Personas" ( "Id" integer NOT NULL, nom1 "char", nom2 "char", apel1 "char", apel2 "char", CONSTRAINT "Personas_pkey" PRIMARY KEY ("Id") ) WITHOUT OIDS; ALTER TABLE "Personas" OWNER TO root; I do really appreciate any help or guidance. Jaison J. Gonz=3DE1lez Chaux -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080111/= dc98de0a/attachment.htm
- Previous message: [Slony1-general] Query about Slony-i from Colombia
- Next message: [Slony1-general] Query about Slony-i from Colombia
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list