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
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