Ashish Karalkar wrote: > Hello All, > > I have to set simple single master slave replication system. > > In my master database i have all the primary keys as "serial" datatype > which implicitly create sequence for the primary key column. > > Now in my slave databse I also have the same databse structure , so > sequences of the primary key will be present there also . > > The question is should replicate sequences of master database primary > keys also? > > I have around 500 table and thus 500 sequence. > > Absolutely, yes, you should replicate those sequences using SET ADD SEQUENCE.
The values coming from the origin node will overwrite values on subscriber nodes, but since you're not allowed to do direct updates to the tables on subscriber nodes, you won't be directly messing with the sequences on subscriber nodes, so this isn't a problem. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
