Re: [HACKERS] Database replication... - Mission Critica

From: Bill Gribble <grib(at)linuxdevel(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Neil Conway <neilc(at)samurai(dot)com>, "Mikheev, Vadim" <VMIKHEEV(at)sectordata(dot)com>, Greg Patnude <GPatnude(at)adelphia(dot)net>, pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] Database replication... - Mission Critica
Date: 2002-11-08 01:51:38
Message-ID: 1036720298.18084.61.camel@firetrap
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, 2002-11-07 at 19:36, Christopher Kings-Lynne wrote:
> Even nastier, what about if the different postgres servers in the cluster
> run on different architectures! That way you'd get different floating point
> results on each machine...

Oh come on! There's no such thing as "perfect" anywhere. I was the one
that originally posted the concept that one could maintain identical
databases by piping queries to two DBs simultaneously. It's clearly
been demonstrated that this is not possible in the general case.
Differing architectures for the servers is the *least* of the problems.

As always, "don't insure what you can afford to lose" and the converse,
"always insure what you can't afford to lose" both apply.

b.g.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2002-11-08 02:28:12 Re: [HACKERS] Database replication... - Mission Critica
Previous Message Thomas T. Thai 2002-11-08 01:42:13 Re: Restoring a db dump with tsearch fields fails

Browse pgsql-hackers by date

  From Date Subject
Next Message Billy G. Allie 2002-11-08 02:11:26 Re: [HACKERS] PostgreSQL supported platform report and a patch.
Previous Message Christopher Kings-Lynne 2002-11-08 01:36:43 Re: [HACKERS] Database replication... - Mission Critica