Thanks Andreas for your replay. Will there not be duplication of same sequence name in slave database? as slave database will have its own sequences of same name as of master database.
With Regards Ashish... ----- Original Message ----- From: "Andreas Kretschmer" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, February 02, 2007 12:07 PM Subject: Re: [Slony1-general] Replicating Sequence?? > 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 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
