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

_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to