Re: High-Availability Question - Mailing list pgsql-general

From Ivan Zolotukhin
Subject Re: High-Availability Question
Date
Msg-id 751e56400607040035p367a4df2n5810aa1d3d16de25@mail.gmail.com
Whole thread Raw
In response to Re: High-Availability Question  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: High-Availability Question  (Chander Ganesan <chander@otg-nc.com>)
List pgsql-general
Hello,

> > Third idea:
> > I install the Slony-I, linux-ha and postgresql on the same server of
> > the two 2U servers. The web application access to the db server
> > directly and without pgpool.

AFAIK, Slony does not have failover capabilities you need in HA solution:

http://gborg.postgresql.org/project/slony1/genpage.php?howto_overview

So you will need pgpool layer (or some other connection manager +
network monitoring software) to detect failures anyway.

Regards,
Ivan Zolotukhin

pgsql-general by date:

Previous
From: "Alex Turner"
Date:
Subject: Re: RAID + PostgreSQL?
Next
From: Franz.Rasper@izb.de
Date:
Subject: Re: RAID + PostgreSQL?