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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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