Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3F0E2477359 for ; Tue, 28 Jan 2003 17:39:00 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id CF76D47743B for ; Tue, 28 Jan 2003 16:12:32 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18dd20-0006Ip-00 for ; Tue, 28 Jan 2003 16:12:32 -0500 Date: Tue, 28 Jan 2003 16:12:32 -0500 From: Andrew Sullivan To: PostgreSQL Admin Subject: Re: Replication Message-ID: <20030128161232.P22543@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , PostgreSQL Admin References: <20030123135353.E4693@mail.libertyrms.com> <20030127181820.C9007@mail.libertyrms.com> <20030128000736.X22851@hub.org> <1043773193.6521.7.camel@lyric.ofsloans.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <1043773193.6521.7.camel@lyric.ofsloans.com>; from will@lashell.net on Tue, Jan 28, 2003 at 09:59:52AM -0700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/314 X-Sequence-Number: 7156 On Tue, Jan 28, 2003 at 09:59:52AM -0700, Will LaShell wrote: > What problems have people been having getting rserv to work at all? In 2001 I tested it for our anticipated load. It worked for me, but it was not up to the kind of load that we were anticipating. It was reasonable, however, and I was not able to break it; it just wasn't up to the load I had to plan for. We also needed multi-salve replication. We therefore did some work with PostgreSQL, Inc. to produce a new, somewhat better version of rserv. That's what we still use in our production systems. So I have not had problems getting rserv to work, but it wasn't enough for us. I wouldn't hesitate to recommend it to others, though: the strategy is sound, and if it meets your needs, it'll probably do fine (assuming it still works with 7.3; when I was testing, remember, 7.1.x was the released version). I seem to recall keeping it busy with several hundred transactions per minute, but whether that was sustainable I don't know. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110