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

From Richard Huxton
Subject Re: Load Balancing and Backup
Date
Msg-id 4099517D.6010206@archonet.com
Whole thread Raw
In response to Re: Load Balancing and Backup  (Steve Atkins <steve@blighty.com>)
List pgsql-general
Steve Atkins wrote:
> On Fri, Apr 30, 2004 at 01:17:16PM -0400, CS Wagner wrote:
>>
>>What I would most desire is a program that pretends to be a postgres
>>server.  I can log into it with psql, a jdbc driver, or php's
>>pg_connect.  When I do a select (no update) command, it will send that
>>off to the least loaded mirror.  When I do an update/insert/delete, it
>>hits all the mirrors.  Also, it can designate one database (most likely
>>local to this pretend server) as the master so I can easily clone it to
>>make more mirrors.
>>
>>Does anything remotely similar to that exist?
>
>
> Sounds like dbbalancer, but I've no idea whether that's ready for
> production use. I supect not.

Possibly pgpool too. See the mailing-list archives for pg-announce (last
month) for the details.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: select for update & lock contention
Next
From: Eric Ridge
Date:
Subject: Changing the size of a varchar field