Re: 7.4?

From: Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>
To:
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 7.4?
Date: 2003-02-28 09:49:08
Message-ID: Pine.LNX.4.44.0302280942570.4305-100000@RedDragon.Childs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 27 Feb 2003, Andrew Sullivan wrote:

> On Thu, Feb 27, 2003 at 02:21:23PM -0700, Ed L. wrote:
> >
> > Unfortunately, dbmirror does go through all the iterations, even if
>
> So does dbmirror keep a copy of the row somewhere? Doesn't that add
> a lot to i/o?
>
> A
>
>
Ok we seam to have quite a lot of talk about replication options
here.
I need to implement one sooner or later....
Which is best seams to be on requirments and not much else. So
perhaps a list of whats currently available, its requirements and what it
is best for would be good on the web site. Here are my requirements.

1> MultiMaster (Database involves quite a lot of writes)
2> 24 x 7 operation so one server must be able to cope while the other
vacuums, backups etc,
3> Consistant all machines that are up must look the same when in master
usage.

The problem as far as I can see with sycronse systems is that they
can't cope with down time and that in my book is the primary reason for
having replication.

Peter Childs
P.S. A Hot Spare might actually be the best answer.... `

In response to

  • Re: 7.4? at 2003-02-27 22:28:49 from Andrew Sullivan

Responses

  • Re: 7.4? at 2003-02-28 15:10:54 from Neil Conway
  • Re: 7.4? at 2003-02-28 18:20:27 from Ed L.
  • Re: 7.4? at 2003-02-28 20:10:57 from Andrew Sullivan

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-02-28 09:59:16 Re: Few Simple Questions
Previous Message Arjen van der Meijden 2003-02-28 09:24:44 Re: phpBB2 slow on postgres vs mysql ?