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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110