Re: postgresql cluster on SAN - Mailing list pgsql-admin

From Robert Ngo
Subject Re: postgresql cluster on SAN
Date
Msg-id 4330F194.90004@perridot.com
Whole thread Raw
In response to postgresql cluster on SAN  (Robert Ngo <robertngo@perridot.com>)
Responses Re: postgresql cluster on SAN  (Chris Travers <chris@metatrontech.com>)
List pgsql-admin
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?

pgsql-admin by date:

Previous
From: Chris Browne
Date:
Subject: Re: postgresql cluster on SAN
Next
From: Scott Eade
Date:
Subject: Searching for a supposedly resolved bug report