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 9BFF0D94A9 for ; Wed, 21 Sep 2005 12:30:55 -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 11010-05 for ; Wed, 21 Sep 2005 15:30:47 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id E14C4D9445 for ; Wed, 21 Sep 2005 12:30:44 -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 j8LFU8be011221 for ; Wed, 21 Sep 2005 15:30:33 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j8LFTUno010903 for pgsql-admin@postgresql.org; Wed, 21 Sep 2005 15:29:30 GMT (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: postgresql cluster on SAN Date: Wed, 21 Sep 2005 09:06:44 -0400 Organization: cbbrowne Computing Inc Lines: 69 Message-ID: <60vf0upo2j.fsf@dba2.int.libertyrms.com> References: <4330ABAE.709@perridot.com> <60zmq7p3oz.fsf@dba2.int.libertyrms.com> <4330D1F2.5000004@perridot.com> <4330F194.90004@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:SYfrpInVt3SUVdXv5Xry5n9xCps= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.477 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.343] X-Spam-Level: X-Archive-Number: 200509/221 X-Sequence-Number: 18958 robertngo@perridot.com (Robert Ngo) writes: > 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? Well, the base amount of storage for each instance is only about 26MB. sh-3.00$ /opt/OXRS/dbs/pgsql8/bin/initdb -D . Success. You can now start the database server using: /opt/OXRS/dbs/pgsql8/bin/postmaster -D . or /opt/OXRS/dbs/pgsql8/bin/pg_ctl -D . -l logfile start sh-3.00$ du 176 ./global 4 ./pg_xlog/archive_status 16412 ./pg_xlog 12 ./pg_clog 12 ./pg_subtrans 4640 ./base/1 4704 ./base/17229 9348 ./base 4 ./pg_tblspc 25992 . sh-3.00$ For any sort of interesting-sized database, this bit of overhead, which is mostly WAL files, doesn't strike me as being terribly material. I can't see 26MB being considered "huge" in a SAN context. You only need additional storage (beyond that) when your applications are actually requesting to store data. There is no magical way to avoid that need for additional storage. -- let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;; http://cbbrowne.com/info/languages.html "The newsreader abuse likely stems from more fundamental, than merely just the UI, design disagreements. Requests from Unix programmers to replicate Free Agent rightfully so should trigger the throwing of sharp heavy objects at the requesting party." -- jedi@dementia.mishnet (jedi)