contrib/DBMirror (Replication).

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