From: | Chris Travers <chris(at)metatrontech(dot)com> |
---|---|
To: | Robert Ngo <robertngo(at)perridot(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: postgresql cluster on SAN |
Date: | 2005-09-21 06:33:14 |
Message-ID: | 4330FEAA.7020806@metatrontech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Robert Ngo wrote:
> 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?
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
Attachment | Content-Type | Size |
---|---|---|
chris.vcf | text/x-vcard | 127 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Eade | 2005-09-21 06:47:02 | Searching for a supposedly resolved bug report |
Previous Message | Robert Ngo | 2005-09-21 05:37:24 | Re: postgresql cluster on SAN |