Re: postgresql cluster on SAN - Mailing list pgsql-admin

From Chris Browne
Subject Re: postgresql cluster on SAN
Date
Msg-id 60zmq7p3oz.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to postgresql cluster on SAN  (Robert Ngo <robertngo@perridot.com>)
List pgsql-admin
robertngo@perridot.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

pgsql-admin by date:

Previous
From: Robert Ngo
Date:
Subject: postgresql cluster on SAN
Next
From: Robert Ngo
Date:
Subject: Re: postgresql cluster on SAN