Skip site navigation (1) Skip section navigation (2)

Re: High Avaliable in the PostgreSQL.

From: Kristo Kaiv <kristo(dot)kaiv(at)skype(dot)net>
To: Fernando Ike de Oliveira <fike(at)midstorm(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: High Avaliable in the PostgreSQL.
Date: 2007-05-31 06:45:06
Message-ID: 4073A396-4641-41A5-83B8-3C190DB772D0@skype.net (view raw or flat)
Thread:
Lists: pgsql-admin
Hi!

We have a PostgreSQL cluster that is runnign on tens of server on  
different colocations.
Failovers / switchovers between colocations can be done per server.  
Uptime has been
 >99.9%. All the software is opensource and has gone through  
intensive live testing.

Our cluster is running on:
skytools: 	
	* londiste (replica)
         * pgq        (generic queueing system)
         * walmgr  (wal replica manager)
http://pgfoundry.org/projects/skytools/

plproxy             (remote calls language)
http://pgfoundry.org/projects/plproxy/

pgbouncer
http://pgfoundry.org/projects/pgbouncer/

BR,
Kristo

On 30.05.2007, at 22:42, Fernando Ike de Oliveira wrote:

> Hi,
>
>
> 	I need solution to PostgreSQL for High Available, originally
> was 99,7% but considering the current necessities, change percentual
> to 99,99%. I think in solution probability  pgpool-2 or Heartbeat +
> GFS. The PostgreSQL servers will be in different physical places.
>
>  	Suggestions?
>
>
>
> Kind Regards,
> -- 
> Fernando Ike
> http://www.midstorm.org/~fike/weblog
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2007-05-31 14:01:53
Subject: Re: Attempt to re-archive existing WAL logs after restoring from backup
Previous:From: adeyDate: 2007-05-31 05:30:20
Subject: Re: High Avaliable in the PostgreSQL.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group