X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9E009D8BC3 for ; Wed, 21 Sep 2005 03:33:22 -0300 (ADT) 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 93885-02 for ; Wed, 21 Sep 2005 06:33:15 +0000 (GMT) Received: from mail.travelamericas.com (unknown [206.130.134.147]) by svr1.postgresql.org (Postfix) with SMTP id 9E6A4D70BF for ; Wed, 21 Sep 2005 03:33:14 -0300 (ADT) Received: (qmail 24911 invoked from network); 21 Sep 2005 06:33:14 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 21 Sep 2005 06:33:14 -0000 Message-ID: <4330FEAA.7020806@metatrontech.com> Date: Tue, 20 Sep 2005 23:33:14 -0700 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Robert Ngo , pgsql-admin@postgresql.org Subject: Re: postgresql cluster on SAN References: <4330ABAE.709@perridot.com> <60zmq7p3oz.fsf@dba2.int.libertyrms.com> <4330D1F2.5000004@perridot.com> <4330F194.90004@perridot.com> In-Reply-To: <4330F194.90004@perridot.com> Content-Type: multipart/mixed; boundary="------------000504030304040400080002" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.047 required=5 tests=[AWL=-0.003, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/254 X-Sequence-Number: 18991 This is a multi-part message in MIME format. --------------000504030304040400080002 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Robert Ngo wrote: > Robert Ngo wrote: > >> Chris Browne wrote: >> >>> robertngo@perridot.com (Robert Ngo) writes: >>> >>> >>>> Can i create create a cluster of postgresql server by sharing the >>>> database file on a SAN? I am also looking into slony but slony >>>> replicate >>>> data to each server and my database will potentially have terabytes of >>>> data. I am thinking about a solution where a cluster of database >>>> server >>>> will share database files on SAN, can this be done? I am also looking >>>> for a load balancing salution for the postgresql database. Any >>>> sugestion? >>>> >>> >>> >>> >>> What you wish can NOT be done. >>> >>> There can only be ONE postmaster for each database cluster; you can >>> NOT have multiple servers sharing a single cluster. >>> >>> >> so there is no ways for the file storage to be shared between >> postgres cluster? Then i will need to add a huge amount of storage >> every time new server is added. >> > Is there any way i can reduce the storage requirement of the database > server cluster? Maybe you can provide us with more information on your environment, application, expected load, etc. so we can help you explore other possibilities. Best Wishes, Chris Travers --------------000504030304040400080002 Content-Type: text/x-vcard; charset=utf-8; name="chris.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="chris.vcf" begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@metatrontech.com x-mozilla-html:FALSE version:2.1 end:vcard --------------000504030304040400080002--