From: Adile Abbadi <adile@minitdrugs.com>
To: pgsql-admin@postgresql.org
Subject: Load Balancing/Multiple Postgres Machines
Date: Mon, 29 Nov 2004 11:34:56 -0700
Message-ID: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com> (raw)
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.
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.
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.
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: adile@minitdrugs.com
Subject: Re: Load Balancing/Multiple Postgres Machines
In-Reply-To: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com>
References: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox