X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C76593A5222 for ; Mon, 29 Nov 2004 18:29:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44893-08 for ; Mon, 29 Nov 2004 18:28:57 +0000 (GMT) Received: from mx4.grouptelecom.net (mx4.grouptelecom.net [216.18.0.123]) by svr1.postgresql.org (Postfix) with ESMTP id F027F3A5210 for ; Mon, 29 Nov 2004 18:28:56 +0000 (GMT) Received: from ADILEMAIN (cgdist1-e10-0-4.cg.sfl.net [139.142.0.161]) by mx4.grouptelecom.net (iPlanet Messaging Server 5.2 Patch 2 (built Jul 14 2004)) with SMTP id <0I7Y004CYDVW7S@mx4.grouptelecom.net> for pgsql-admin@postgresql.org; Mon, 29 Nov 2004 10:26:21 -0800 (PST) Date: Mon, 29 Nov 2004 11:34:56 -0700 From: Adile Abbadi Subject: Load Balancing/Multiple Postgres Machines To: pgsql-admin@postgresql.org Message-id: MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Content-type: multipart/alternative; boundary="Boundary_(ID_Za+048zzPRgMtkci1sQB4g)" Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200411/197 X-Sequence-Number: 15580 This is a multi-part message in MIME format. --Boundary_(ID_Za+048zzPRgMtkci1sQB4g) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT 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 --Boundary_(ID_Za+048zzPRgMtkci1sQB4g) Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: 7BIT
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
 
--Boundary_(ID_Za+048zzPRgMtkci1sQB4g)--