John Sidney-Woollett johnsw
Sat Jan 7 06:20:53 PST 2006
I need to add a single sequence to an existing replicated set (slony 
1.1.0 and Postgres 7.4.6)

I remember that it is not advised to have a set with a single sequence 
(although I can't remember why).

So how can I add a sequence so that it is replicated?

Which of these scenarios is OK?

1) Create temp set. Add sequence to it. Subscribe all slaves to it. 
Merge with existing set.

2) Drop existing set. Recreate the set (same ID), add the orginal 
tables, sequences (with their previous IDs) and the extra new sequence 
(with a new ID). Subscribe all slaves to this set.

The set currently contains 1 table with 2 rows, and 1 sequence. And I 
only need to add one extra sequence to the set.

Which option is better/easier/less likely to cause problems? Are both valid?

Thanks

John



More information about the Slony1-general mailing list