Re: postgresql cluster on SAN

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?