Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-31 Thread Andrew Sullivan
On Thu, May 31, 2007 at 05:30:20PM +1200, adey wrote: > HP was providing CA (Continuous Access) software that was claimed to provide > WAN SAN replication by repeating IO in exactly the sequence it was generated > on the master, to the slave. The CA stuff, or anything else built on FCIP, is prett

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread Kristo Kaiv
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: s

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread adey
HP was providing CA (Continuous Access) software that was claimed to provide WAN SAN replication by repeating IO in exactly the sequence it was generated on the master, to the slave. SO while there was a delay, updates on the slave would be sequentially intact, providing a good level of integrity

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread Andrew Sullivan
On Wed, May 30, 2007 at 06:12:02PM -0400, Adam Tauno Williams wrote: > > Sure it can be done. Get two SANs that support replication, redundant > high-speed WAN links, high end servers, large UPSs, and generators. Most SANs that I've seen aren't in "geographically separate" locations in the way m

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread Adam Tauno Williams
On Wed, 2007-05-30 at 17:18 -0400, Andrew Sullivan wrote: > On Wed, May 30, 2007 at 04:42:08PM -0300, Fernando Ike de Oliveira wrote: > > was 99,7% but considering the current necessities, change percentual > > to 99,99%. I think in solution probability pgpool-2 or Heartbeat + > > GFS. The Postgre

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread Andrew Sullivan
On Wed, May 30, 2007 at 04:42:08PM -0300, Fernando Ike de Oliveira wrote: > 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. I would be ver

Re: [ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread gonzales
Different physical places, I hope high bandwidth + low latency :) On Wed, 30 May 2007, 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

[ADMIN] High Avaliable in the PostgreSQL.

2007-05-30 Thread Fernando Ike de Oliveira
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