From: | Robert Ngo <robertngo(at)perridot(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: postgresql cluster on SAN |
Date: | 2005-09-21 05:37:24 |
Message-ID: | 4330F194.90004@perridot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Robert Ngo wrote:
> Chris Browne wrote:
>
>> robertngo(at)perridot(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Travers | 2005-09-21 06:33:14 | Re: postgresql cluster on SAN |
Previous Message | Chris Browne | 2005-09-21 02:14:36 | Re: postgresql cluster on SAN |