am Fri, dem 02.02.2007, um 10:59:59 +0530 mailte Ashish Karalkar folgendes: > 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?
Yes. Use 'SET ADD SEQUENCE' for this. http://gborg.postgresql.org/project/slony1/genpage.php?slonik_commands#stmt_set_add_sequence Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
