Re: 7.4?
Peter Childs <blue.dragon@blueyonder.co.uk>
From: Peter Childs <blue.dragon@blueyonder.co.uk>
To:
Cc: PostgreSQL General <pgsql-general@postgresql.org>
Date: 2003-02-28T09:49:08Z
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.... `