Re: Replication - Mailing list pgsql-admin

From Marc G. Fournier
Subject Re: Replication
Date
Msg-id 20030128134750.V22851@hub.org
Whole thread Raw
In response to Re: Replication  (Will LaShell <will@lashell.net>)
Responses Re: Replication  (Will LaShell <will@lashell.net>)
List pgsql-admin
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 <args> (sets up master and initial slave)

and a foreach loop based on a psql -l on the database to run:

./ers_addtable <tablename>

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 ...


pgsql-admin by date:

Previous
From: Will LaShell
Date:
Subject: Re: Replication
Next
From: "dr. dave"
Date:
Subject: Re: New User - Please Help