Replication, High availability
Replication, High availability
От:
Wojciech Bernacki <bero@media.net.pl>
Дата:
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
Re: Replication, High availability
От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
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
M2P 2A8
+1 416 646 3304 x110