Sat Jan 7 06:20:53 PST 2006
- Previous message: [Slony1-general] Slony and Network Delays
- Next message: [Slony1-general] Add single sequence to replicated set
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony and Network Delays
- Next message: [Slony1-general] Add single sequence to replicated set
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list