On Jan 21, 2005, at 1:57 PM, John Sidney-Woollett wrote:

I can't answer all your q's so I'll pick and choose :-)

> Question 1) Is a psql script writing the ordered table data to a file 
> and then diff the files from the two databases the best way to do 
> this?

yep.  but you could probably cheat and just do md5 on both files.

>
> Question 2) We have noticed one sequence that wasn't being replicated 
> (our mistake) and we want to add that to one of the existing sets. Is 
> SET ADD SEQUENCE (to a new set), MERGE SET (new set, existing set) the 
> correct way to do this? Can the new set ID be an existing one? And can 
> the new ID be re-used after the merge command?

you also have to subscribe everyone to the new set before you can merge 
it.  both sets must have identical subscribers and origins.  once 
you've done the merge, the "new" ID you were using is free to be used 
again.

> Question 3) We want to check that all sequence values are >= max PK 
> value for the tables in which they are used. Does anyone know how to 
> check this without calling nextval() - is it possible to query the 
> system tables (and if so how)?
>

select * from foobar_seq;

will report the values of your sequence.  it is just a "special" table.


Vivek Khera, Ph.D.
+1-301-869-4449 x806