Skip site navigation (1) Skip section navigation (2)

Re: Load Balancing/Multiple Postgres Machines

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Adile Abbadi <adile(at)minitdrugs(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Load Balancing/Multiple Postgres Machines
Date: 2004-11-30 21:45:35
Message-ID: 41ACE9FF.5090605@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Attachment: jd.vcf
Description: text/x-vcard (640 bytes)

In response to

pgsql-admin by date

Next:From: IainDate: 2004-12-01 01:47:16
Subject: Re: Load Balancing/Multiple Postgres Machines
Previous:From: Adile AbbadiDate: 2004-11-30 21:26:51
Subject: Re: Load Balancing/Multiple Postgres Machines

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group