Re: Question: Clustering & Load Balancing - Mailing list pgsql-performance

From Michal Taborsky - Internet Mall
Subject Re: Question: Clustering & Load Balancing
Date
Msg-id 45895BAB.9040203@mall.cz
Whole thread Raw
In response to Question: Clustering & Load Balancing  (CARMODA <carmoda@gmail.com>)
List pgsql-performance
CARMODA napsal(a):
> has anyone here had any good/bad experiences clustering & load balancing
> a PostgreSQL server on Redhat (ES)?

We have recently successfully rolled-out a solution consisting of two
PostgreSQL database backends replicated by Slony. The backends are
accessed from a bunch of application servers (Apache) via pgpool. We
have some shell scripts around it to handle monitoring, failover and
switch-over. It is built on CentOS4 (ie. RedHat ES4). It's pretty solid.

--
Michal Táborský
chief systems architect
Internet Mall, a.s.
<http://www.MALL.cz>


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: GROUP BY vs DISTINCT
Next
From: "Jeremy Haile"
Date:
Subject: URGENT: Out of disk space pg_xlog