Pradeep Parmar <parmarpradeep at gmail.com> schrieb:

> 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

You need a primary key on each replicated table. If you haven't a
primary key, you *must* add one. You can use slonik for this:

table add key (node id = 1, fully qualified name = 'public.staff');

This adds a bigint column named _Slony-I_$CLUSTERNAME_rowID to this
table.

Please read the documentation about slony, for instance this:
http://linuxfinances.info/info/slonyadmin.html



Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082?, E 13.56889?