Skip site navigation (1) Skip section navigation (2)

Re: postgresql cluster on SAN

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 (view raw or flat)
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: chris.vcf
Description: text/x-vcard (127 bytes)

In response to

pgsql-admin by date

Next:From: Scott EadeDate: 2005-09-21 06:47:02
Subject: Searching for a supposedly resolved bug report
Previous:From: Robert NgoDate: 2005-09-21 05:37:24
Subject: Re: postgresql cluster on SAN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group