pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Travers <chris@metatrontech.com>
To: Robert Ngo <robertngo@perridot.com>
To: pgsql-admin@postgresql.org
Subject: Re: postgresql cluster on SAN
Date: Tue, 20 Sep 2005 23:33:14 -0700
Message-ID: <4330FEAA.7020806@metatrontech.com> (raw)
In-Reply-To: <4330F194.90004@perridot.com>
References: <4330ABAE.709@perridot.com>
	<60zmq7p3oz.fsf@dba2.int.libertyrms.com>
	<4330D1F2.5000004@perridot.com>
	<4330F194.90004@perridot.com>

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

Attachments:

chris.vcf (text/x-vcard, 125B) download begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@metatrontech.com x-mozilla-html:FALSE version:2.1 end:vcard

view thread (12+ messages)  latest in thread

Message-ID: <4330FEAA.7020806@metatrontech.com>
Permalink:  ../4330FEAA.7020806@metatrontech.com/
Also on:    postgresql.org/message-id/4330FEAA.7020806@metatrontech.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: chris@metatrontech.com, robertngo@perridot.com
  Subject: Re: postgresql cluster on SAN
  In-Reply-To: <4330FEAA.7020806@metatrontech.com>
  References: <4330ABAE.709@perridot.com> <60zmq7p3oz.fsf@dba2.int.libertyrms.com> <4330D1F2.5000004@perridot.com> <4330F194.90004@perridot.com> <4330FEAA.7020806@metatrontech.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