Re: Load Balancing and Backup - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: Load Balancing and Backup
Date
Msg-id 2315.192.168.0.64.1083793816.squirrel@mercury.wardbrook.com
Whole thread Raw
In response to Re: Load Balancing and Backup  (Dardo D Kleiner - CONTRACTOR <dkleiner@cmf.nrl.navy.mil>)
List pgsql-general
Dardo D Kleiner - CONTRACTOR said:
> http://c-jdbc.objectweb.org/

If you're not using java, this may be an interesting alternative solution
which was recently announced (on this list). It seems to meet quite a few
of your requirements.

John Sidney-Woollett

<quote>
pgpool 1.0, yet another open source replication software for
PostgreSQL is now available at:

ftp://ftp.sra.co.jp/pub/cmd/postgres/pgpool/pgpool-1.0.tar.gz

pgpool is a single master/query based/synchronous replication
server. It acts as a proxy server between PostgreSQL client and
PostgreSQL server. No application change is needed to use pgpool.
pgpool's features include:

o connection pooling. This will reduce the connection establishing
  overhead.

o pre-forking child processes. Like Apache, pgpool pre-forks child
  processes to provide faster service startup.

o degeneration. In the replication mode, if one of PostgreSQL goes
  down, it detaches the broken server and continues operation with the
  surviving server.

o fail over. In the connection pool server mode, if master PostgreSQL
  goes down, it detaches the broken server and continues operation
  with the stand-by server.

pgpool can work with PostgreSQL 7.0 to 7.4. It's small and easy to
install. All you need is gcc. You even do not need PostgreSQL source
tree.

Enjoy,
--
Tatsuo Ishii

</quote>


pgsql-general by date:

Previous
From: jarednevans@yahoo.com (Jared Evans)
Date:
Subject: 7.2 or 7.4 for critical data?
Next
From: Alvaro Herrera
Date:
Subject: Re: Problem with commandprompt.com