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 1B6BAD9493 for ; Tue, 20 Sep 2005 23:29:40 -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 30766-06 for ; Wed, 21 Sep 2005 02:29:29 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 614F1D94B4 for ; Tue, 20 Sep 2005 23:29:32 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j8L2TTEh033297 for ; Wed, 21 Sep 2005 02:29:29 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j8L2G7DL030635 for pgsql-admin@postgresql.org; Wed, 21 Sep 2005 02:16:07 GMT (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: postgresql cluster on SAN Date: Tue, 20 Sep 2005 22:14:36 -0400 Organization: cbbrowne Computing Inc Lines: 19 Message-ID: <60zmq7p3oz.fsf@dba2.int.libertyrms.com> References: <4330ABAE.709@perridot.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:4NzUaWp2sGBE2nilUK9wct3ydhA= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.478 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.342] X-Spam-Level: X-Archive-Number: 200509/209 X-Sequence-Number: 18946 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. -- (reverse (concatenate 'string "gro.gultn" "@" "enworbbc")) http://cbbrowne.com/info/internet.html "The real romance is out ahead and yet to come. The computer revolution hasn't started yet. Don't be misled by the enormous flow of money into bad defacto standards for unsophisticated buyers using poor adaptations of incomplete ideas." -- Alan Kay