Many thanks for your answers - that will definitely help me get started.

Thank you!

John Sidney-Woollett

Vivek Khera wrote:

> 
> 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
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general