Hi,
I was trying setting up slony on two diff. nodes. Node A as master server
and Node B as slave
Database has just two tables , one of the tables doesn't has a primary key
so i have used the table add key in the slonik commands script. I'm getting
the below error
<stdin>:7: PGRES_FATAL_ERROR select "_slash".determineIdxnameUnique('
public.staff', NULL); - ERROR: Slony-I: table "public"."staff" has no
primary key
Script looks like this :
cluster name = $CLUSTERNAME;
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
user=$REPLICATIONUSER';
node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST
user=$REPLICATIONUSER';
init cluster ( id=1, comment = 'Master Node');
table add key (node id = 1, fully qualified name = 'public.staff');table
add key (node id = 1, fully qualified name = 'public.staff');
create set (id=1, origin=1, comment='All tables');
set add table (set id=1, origin=1, id=1, fully qualified name = '
public.staff', comment='staff table');
set add table (set id=1, origin=1, id=1, fully qualified name = '
public.emp', comment='emp table');
store node (id=2, comment = 'Slave node');
store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME
host=$MASTERHOST user=$REPLICATIONUSER');
store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME
host=$SLAVEHOST user=$REPLICATIONUSER');
store listen (origin=1, provider = 1, receiver =2);
store listen (origin=2, provider = 2, receiver =1);
Please help me out in this...
Rgds
--
Pradeep Parmar
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
