Hi,

I've been going through the tutorial for Replicating Your First Database and
I have a few questions before I touch our  production database.

1)       in the set add table part of the first script, is there a way for
me to determine in postgres, which of the tables in a db ( that I didn't
design) that do not have a primary key (sort of like the history table in
the example) before I run this script. I don't want to have to trip over an
error each time, I'd like to pre-empt this with a key = serial.

 

2)       in the third script (the one that validates that the replicated db
is the same as the master), should I include sequences as well as tables for
this comparison?

 

Thanks in advance, Mick

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061009/e51926b9/attachment.html