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

Re: postgresql cluster on SAN

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 (view raw or flat)
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?

In response to

Responses

pgsql-admin by date

Next:From: Chris TraversDate: 2005-09-21 06:33:14
Subject: Re: postgresql cluster on SAN
Previous:From: Chris BrowneDate: 2005-09-21 02:14:36
Subject: Re: postgresql cluster on SAN

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