Thread: contrib/DBMirror (Replication).
I've attatched the replication system(an alternative to Rserv) that I mentioned the other day in pgsql-hackers. I'd like it if the project can be added as a contrib project to the 7.3 development tree(When its created). The project contains a trigger written in C, a mirroring Perl script and some setup SQL along with documentation. The key features the system has are: -Support for multiple slaves. -Preserves transactions while mirroring. -Per table selection of what tables get mirrored. More details can be found in the README file. -- Steven Singer ssinger@navtechinc.com Aircraft Performance Systems Phone: 519-747-1170 ext 282 Navtech Systems Support Inc. AFTN: CYYZXNSX SITA: YYZNSCR Waterloo, Ontario ARINC: YKFNSCR
Attachment
This has been saved for the 7.3 release: http://candle.pha.pa.us/cgi-bin/pgpatches2 --------------------------------------------------------------------------- Steven Singer wrote: > > > I've attatched the replication system(an alternative to Rserv) that > I mentioned the other day in pgsql-hackers. > > I'd like it if the project can be added as a contrib project to the 7.3 > development tree(When its created). > > > The project contains a trigger written in C, a mirroring Perl script > and some setup SQL along with documentation. > > The key features the system has are: > > -Support for multiple slaves. > -Preserves transactions while mirroring. > -Per table selection of what tables get mirrored. > > More details can be found in the README file. > > > > > -- > Steven Singer ssinger@navtechinc.com > Aircraft Performance Systems Phone: 519-747-1170 ext 282 > Navtech Systems Support Inc. AFTN: CYYZXNSX SITA: YYZNSCR > Waterloo, Ontario ARINC: YKFNSCR > > Content-Description: [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --------------------------------------------------------------------------- Steven Singer wrote: > > > I've attatched the replication system(an alternative to Rserv) that > I mentioned the other day in pgsql-hackers. > > I'd like it if the project can be added as a contrib project to the 7.3 > development tree(When its created). > > > The project contains a trigger written in C, a mirroring Perl script > and some setup SQL along with documentation. > > The key features the system has are: > > -Support for multiple slaves. > -Preserves transactions while mirroring. > -Per table selection of what tables get mirrored. > > More details can be found in the README file. > > > > > -- > Steven Singer ssinger@navtechinc.com > Aircraft Performance Systems Phone: 519-747-1170 ext 282 > Navtech Systems Support Inc. AFTN: CYYZXNSX SITA: YYZNSCR > Waterloo, Ontario ARINC: YKFNSCR > > Content-Description: [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
This patch has been applied by someone recently. Thanks. --------------------------------------------------------------------------- Steven Singer wrote: > > > I've attatched the replication system(an alternative to Rserv) that > I mentioned the other day in pgsql-hackers. > > I'd like it if the project can be added as a contrib project to the 7.3 > development tree(When its created). > > > The project contains a trigger written in C, a mirroring Perl script > and some setup SQL along with documentation. > > The key features the system has are: > > -Support for multiple slaves. > -Preserves transactions while mirroring. > -Per table selection of what tables get mirrored. > > More details can be found in the README file. > > > > > -- > Steven Singer ssinger@navtechinc.com > Aircraft Performance Systems Phone: 519-747-1170 ext 282 > Navtech Systems Support Inc. AFTN: CYYZXNSX SITA: YYZNSCR > Waterloo, Ontario ARINC: YKFNSCR > > Content-Description: [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026