3 x PostgreSQL in cluster/redunant

From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: 3 x PostgreSQL in cluster/redunant
Date: 2005-11-14 18:36:44
Message-ID: 20051114183643.GH20586@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello *,

I have three Sun Server where I have reserved on each Server a Raid-5
of 1 TByte for my PostgreSQL. The first PostgreSQL is up and running
with a database of 150 GByte.

Now I like to make the three Sun Servers redunant but I do not find
any usefull HOWTO's or manuals how to setup PostgreSQL to work redunant.

Can anyone point me to the right documentation please?

How can I redirect requests to one of the other PostgreSQL servers, if
one has to much load ?

My servers have only 32 CPU's of 650 MHz and 64 GByte of memory running
Debian GNU/Linux 3.1 (sparc), and they must support around 17.000 $USER
currently.

The Internet connection is curently for Testing an E1 (with Backup) but
I am looking for FiberOptic Provider E1/STM1.

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mikael Carneholm 2005-11-14 19:59:19 Queries causing highest I/O load since pg_stat_reset?
Previous Message Tom Lane 2005-11-14 18:12:36 Re: Bug with index-usage?