Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6C680478BD9 for ; Tue, 28 Jan 2003 14:04:22 -0500 (EST) Received: from hub.org (hub.org [64.49.215.141]) by postgresql.org (Postfix) with ESMTP id 9A38D477099 for ; Tue, 28 Jan 2003 13:01:53 -0500 (EST) Received: from hub.org (hub.org [64.49.215.141]) by hub.org (Postfix) with ESMTP id 4FD7A8A8C63; Tue, 28 Jan 2003 14:01:52 -0400 (AST) Date: Tue, 28 Jan 2003 14:01:52 -0400 (AST) From: "Marc G. Fournier" To: Will LaShell Cc: Andrew Sullivan , PostgreSQL Admin Subject: Re: Replication In-Reply-To: <1043773193.6521.7.camel@lyric.ofsloans.com> Message-ID: <20030128134750.V22851@hub.org> 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 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/308 X-Sequence-Number: 7150 On Tue, 28 Jan 2003, Will LaShell wrote: > Hrmm, this is kind of sad. rserv actually does work pretty well. We use > it in a production environment here at OFS on a medium size database > cluster. I think you are the first person taht I've seen that has admit'd to using it ... other then a few 'build related' issues, I've never seen anyone do anything with it ... > The biggest issue we had was when we created replication id's to use was > that we used bigint field type for the id. Which as we all know suck > rocks to use in postgres. Once we specifically cast the field to let it > use the index the whole thing just magically worked nice and fast. Note > that it did work before it just worked a whole lot slower. > > What problems have been reported with 7.3? The biggest one I've heard: documentation sucks > Additionally, aren't the eRserver maintainers in theory releasing > updates to rserv every year or so? ( At least that's what has been said > in the past. ) Actually, eRServer right now is nowhere near what you are using right now ... over the past few months, its been re-written in Java and is now multi-slave ... I got my first "live" experience with it this past weekend (I did alot of work on the new perl scripts for administrative, but never had time to actually get it live) ... we used PgMarket as a 'test' case for a demo, and setup consisted of: ./ers_setup (sets up master and initial slave) and a foreach loop based on a psql -l on the database to run: ./ers_addtable The servers were configured so that if you pull'd the plug out of the master server, everything auto-fail'd over to the slave, so that it was transparent to anyone hitting the site ... we even had the web servers themselves in a failover state ...