Обсуждение: 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
Вложения
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