X-Original-To: pgsql-general-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3689A9FA192 for ; Fri, 30 Jun 2006 14:42:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 87612-01 for ; Fri, 30 Jun 2006 14:41:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 850CB9FA0EC for ; Fri, 30 Jun 2006 14:41:57 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k5UHfrQu025396; Fri, 30 Jun 2006 13:41:53 -0400 (EDT) To: David Fetter cc: Scott Marlowe , Jason McManus , pgsql general Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL In-reply-to: <20060630173037.GC7035@fetter.org> References: <1151680333.13129.55.camel@state.g2switchworks.com> <24350.1151681944@sss.pgh.pa.us> <20060630173037.GC7035@fetter.org> Comments: In-reply-to David Fetter message dated "Fri, 30 Jun 2006 10:30:37 -0700" Date: Fri, 30 Jun 2006 13:41:53 -0400 Message-ID: <25395.1151689313@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/1237 X-Sequence-Number: 97609 David Fetter writes: > On Fri, Jun 30, 2006 at 11:39:04AM -0400, Tom Lane wrote: >> It might be worth pointing out that mysql's replication falls over >> if you so much as look at it crosseyed. I have not had to use it >> for production purposes, but I can tell you that the mysql >> replication regression tests fail ... irreproducibly of course ... >> almost one time in two in Red Hat's build environment. > Are those tests, or at least descriptions of them, available? Sure, it's just the standard "make test" sequence in mysql's source. If you want to do exactly what I'm talking about, grab the latest mysql SRPM off the Fedora download server and "rpmbuild --rebuild" it. There's a very long regression test suite (much larger than ours :-() and when it fails, it's invariably in one of the replication-related tests. regards, tom lane