pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: postgresql cluster on SAN
Date: Wed, 21 Sep 2005 09:06:44 -0400
Message-ID: <60vf0upo2j.fsf@dba2.int.libertyrms.com> (raw)
References: <4330ABAE.709@perridot.com>
	<60zmq7p3oz.fsf@dba2.int.libertyrms.com>
	<4330D1F2.5000004@perridot.com>
	<4330F194.90004@perridot.com>

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)



view thread (12+ messages)  latest in thread

Message-ID: <60vf0upo2j.fsf@dba2.int.libertyrms.com>
Permalink:  ../60vf0upo2j.fsf@dba2.int.libertyrms.com/
Also on:    postgresql.org/message-id/60vf0upo2j.fsf@dba2.int.libertyrms.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: cbbrowne@acm.org
  Subject: Re: postgresql cluster on SAN
  In-Reply-To: <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> <60vf0upo2j.fsf@dba2.int.libertyrms.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox