robertngo@xxxxxxxxxxxx (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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
