Search Postgresql Archives

Re: 3 x PostgreSQL in cluster/redunant

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 2005-11-14 at 12:36, Michelle Konzack wrote:
> 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.

You want to look at a couple of different options.

slony http://gborg.postgresql.org/project/slony1/projdisplay.php
pgpool http://pgpool.projects.postgresql.org/
mammoth replicator
http://www.commandprompt.com/products/mammothreplicator
pgcluster http://pgfoundry.org/projects/pgcluster/





---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux