* Andreas Kretschmer <akretschmer at spamfence.net> [061123 13:55]:
> 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');

Although in the practice, it's way less painful to have an application
level key added. table add key generated keys tend to be painful when
it comes to backups.

Andreas