Re: Load sharing question

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
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110