From: | Kieran <kieran(at)dunelm(dot)org(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Enterprise readiness - mirroring / incremental backup solutions? |
Date: | 2002-11-19 16:18:35 |
Message-ID: | 3DDA645B.5040104@dunelm.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Kieran wrote:
> I'm currently starting to evaluate Open Source RDBMSs for use in a
> high-volume, high-availability environment.
>
> <rest snipped>
OK, thanks to all who replied.
In case anyone's curious as to the motivation of my question, I've been
asked to look into rough first year hardware + software costs required
for a 'web services' offering, assuming it'll go live Q4 2004. (And how
to minimise them!).
So far, the only major non in-house software component where an open
source product is not quite ready for what we want to do is the RDBMS.
I'm guessing that an RDBMS with full transaction + recovery support is
of similar (if not greater) complexity than a POSIX kernel, and far more
complex than a web server. But I'm sure PostgreSQL developers already
know that....
Now I've got some pointers, I'm going to have to do some more research
myself, but from what I gather, it looks like there's a good chance that
by version 7.4 PostgreSQL will be able to compete with Oracle / Informix
for the particular application domain I'm interested in.
Certainly, the pgreplication project looks very encouraging, as does the
Point-in-time recovery mentioned. I'll also look into the (non-free)
eRServer, as well as rserv and dbmirror. As Tom Lane pointed out,
focusing on mirroring to a remote slave rather than requiring
incremental backup does make more sense (at least to me).
Unfortunately I'm not in a position to pay external developers even
though I suspect doing so would be cheaper than, say, a 16-CPU Oracle
licence :-). Hopefully, we'll eventually be able to contribute something
back either to PostgreSQL or the open source community in general.
Thanks once again,
Regards,
Kieran Elby
From | Date | Subject | |
---|---|---|---|
Next Message | Damjan Pipan | 2002-11-19 17:41:43 | Re: plpgsql - accessing field in RECORD variable by text variables |
Previous Message | Tom Lane | 2002-11-19 15:47:06 | Re: plpgsql - accessing field in RECORD variable by text variables |