Re: Load Balancing/Multiple Postgres Machines

Adile Abbadi wrote:
> Thank you very Joshua for your help - Glad to hear my hardware should be
> able to handle my needs and there is something out there. Do you know of any
> documentation or online help that I could refer on the apps listed below?
> Also are they separate apps that are to be installed and configured outside
> postgres or are they included with the postgres build?

Slony: www.slony.info
Mammoth Replicator: www.commandprompt.com
PgPool: http://www2b.biglobe.ne.jp/~caco/pgpool/index-e.html

>
> Cheers
>
> Adile
>
>
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
> Sent: November 29, 2004 12:30 PM
> To: Adile Abbadi
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Load Balancing/Multiple Postgres Machines
>
>
> Adile Abbadi wrote:
>
>>Hi all,
>>
>>Not sure if this has been asked before - it probably has been - but I
>
> figure
>
>>its probably just easier if I ask so my question is this:
>>
>>How easy is it - or rather is it possible to create multiple instances of
>>the same db on multiple machines?
>>
>>We are currently running a very highly used postgres db (Ver 7.2) that
>
> eats
>
>>up a lot of cpu time when its heavily used. We recently bought some very
>>powerful equipment to accommodate this high use, (currently its on a
>
> single
>
>>CPU, 1GB of Ram SCSI server - upgraded to a dual CPU, 4GB of ram SCSI
>>server) but my fear is over time this issue is going to haunt me again and
>>hardware can only be upgraded so much.
>
>
> Well you have a very long way to go before you get to that "too much" stage.
>
> Within your current platform it should be possible to upgrade to 8GB of
> ram and you can almost always add more hard drives.
>
>
>>So is it possible to do some level of load balancing in postgres - I would
>>love a situation where I could have multiple machines running multiple
>>instances of the same db (that are all synced in real-time), where there
>
> is
>
>>some smart level of load balancing happening.
>
>
> You may want to look at pgpool, slony or Mammoth Replicator.
>
>
>
>>So if it is possible is there some instruction info out there to help me
>>along my way. Any help or insight would be greatly appreciated.
>
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
>
>>All the best
>>
>>Adile
>>
>>---
>>Outgoing mail is certified Virus Free.
>>Checked by AVG anti-virus system (http://www.grisoft.com).
>>Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/04
>>
>
>
>
> --
> Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
> Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/04
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/04

--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL