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

Re: postgresql cluster on SAN

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgresql cluster on SAN
Date: 2005-09-21 02:14:36
Message-ID: 60zmq7p3oz.fsf@dba2.int.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.
-- 
(reverse (concatenate 'string "gro.gultn" "@" "enworbbc"))
http://cbbrowne.com/info/internet.html
"The real  romance is   out   ahead and   yet to come.    The computer
revolution hasn't started yet. Don't be misled by the enormous flow of
money into bad defacto standards for unsophisticated buyers using poor
adaptations of incomplete ideas." -- Alan Kay

In response to

Responses

pgsql-admin by date

Next:From: Robert NgoDate: 2005-09-21 05:37:24
Subject: Re: postgresql cluster on SAN
Previous:From: Robert NgoDate: 2005-09-21 00:39:10
Subject: postgresql cluster on SAN

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