Обсуждение: Replication, High availability

    My online app uses PostgreSQL 7.2 running on a single Debian box. I also have
a spare machine witch may act as a backup server. After even hardware
breakdowns the whole system must be up and running in no more than couple of
minutes. How to achieve this goal? Is Postgresql-R 7.2 already worth trying?
Has anyone used drbd or Coda in simmilar cases? Can you share your
experiences? Thanks in advance for any suggestions.

    Wojciech Bernacki

On Sun, Sep 29, 2002 at 12:06:40PM +0200, Wojciech Bernacki wrote:

> goal? Is Postgresql-R 7.2 already worth trying? Has anyone used

No.  It's only just been made to work this summer, and the patches
haven't been merged with the main PsotgreSQL code.  If reliability is
what you want, don't use bleeding-edge tools.

We use eRserver from PostgreSQL, Inc.  It's commercial, but it works
very well for us.

There is a contrib/ set of files called dbmirror which others have
had success with.

Neither of these does "hot failover".  In other words, no matter what
you use, you'll be needing a pager.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110