pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: chw@clearmetrix.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Help on creating a High Availability PostgreSQL
Date: Fri, 25 Oct 2002 10:26:56 +0900 (JST)
Message-ID: <20021025.102656.26521716.t-ishii@sra.co.jp> (raw)
In-Reply-To: <3DB8034A.10903@clearmetrix.com>
References: <3DB8034A.10903@clearmetrix.com>

> We are looking to create a two-machine high-availability configuration 
> for PostgreSQL.  We have been pursuing using something like rserv, but 
> this appears to be more of a slave sync tool.  Actually, this is also 
> important to us (as we expect we will need to scale to lots of readers 
> doing queries on the database (we are running  datamart of website 
> performance metrics).
> 
> But, rserv (and eRServer, its commercial cousin) dont seem to have a 
> hot-standby capability at the moment.  I have looked through some of the 
> PostgreSQL archives and I've seen articles about other approaches, but I 
> mostly see replication engines (which are a good thing, but not what I 
> am hunting for).
> 
> I saw one posting that suggested using a clustered filesystem; is this 
> an option?  Has anyone done postgreSQL on a replicating/clustered file 
> system with decent performance?  Any and all ideas are welcome.

We are selling Lifekeeper (a hot-standby cluster software) +
PostgreSQL adapter software for Lifekeeper + support combo package
called "PostgreSQL HA package" in Japan. This requires an expensive
shared disk hardware though.
--
Tatsuo Ishii

view thread (2+ messages)

Message-ID: <20021025.102656.26521716.t-ishii@sra.co.jp>
Permalink:  ../20021025.102656.26521716.t-ishii@sra.co.jp/
Also on:    postgresql.org/message-id/20021025.102656.26521716.t-ishii@sra.co.jp

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: t-ishii@sra.co.jp, chw@clearmetrix.com
  Subject: Re: Help on creating a High Availability PostgreSQL
  In-Reply-To: <20021025.102656.26521716.t-ishii@sra.co.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox