Re: Load sharing question

-- Thanks for the response.

-- Right now, all I want to do is some load balancing ( I'm
-- sorry ... I should have said this instead of sharing)
-- techniques (reviewing MOSIX docs http://www.mosix.cs.huji.ac.il/)
-- for PostgreSQL. I just want to spread the workload
-- from one machine to multiple machines and *not* run
-- duplicate versions of the database.

-- I must say, however, that Postgres-R sounds very interesting.

-X

On Mon, Sep 09, 2002 at 12:09:55PM -0400, Johnson, Shaunn wrote:
> Howdy:
>
> Running RedHat Linux 2.4.7-10 and PostgreSQL 7.2.1
> on an Intel box.
>
> Has anyone configured their machines to do load sharing
> (and to a greater extent, clustering) for PostgreSQL?

What, exactly, are you thinking of doing here? Is this "make a copy
of the database and use it for read-only queries?" In that case,
it's easy: use one of the myriad replication packages and catch
inbound SELECTs with your client; then just redirect them. Do 'whois
afilais.info' for a working example of exactly this.

If what you mean is sharing the read and write load across two
database machines, you can't really do that right now. When
Postgres-R is finished, it should be possible. But it isn't right
now.

A
--