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 D77043A45B0 for ; Tue, 30 Nov 2004 21:23:25 +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 40654-07 for ; Tue, 30 Nov 2004 21:23:04 +0000 (GMT) Received: from mx4.grouptelecom.net (mx4.grouptelecom.net [216.18.0.123]) by svr1.postgresql.org (Postfix) with ESMTP id 28C313A4454 for ; Tue, 30 Nov 2004 21:23:04 +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 <0I8000BVRGLZZ3@mx4.grouptelecom.net> for pgsql-admin@postgresql.org; Tue, 30 Nov 2004 13:20:23 -0800 (PST) Date: Tue, 30 Nov 2004 14:23:24 -0700 From: Adile Abbadi Subject: Re: Load Balancing/Multiple Postgres Machines In-reply-to: <41AB78C8.2070605@commandprompt.com> To: "Joshua D. Drake" Cc: 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: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT 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 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/4 X-Sequence-Number: 15588 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? Cheers Adile -----Original Message----- From: Joshua D. Drake [mailto:jd@commandprompt.com] Sent: November 29, 2004 12:30 PM To: Adile Abbadi Cc: pgsql-admin@postgresql.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@commandprompt.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