Pradeep Parmar <[EMAIL PROTECTED]> 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°
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
