This is possible. Below is a brief recipe. 1. Use Veritas Storage Foundation HA with Cluster File System. 2. Have a volume with cfs available to 2 or more systems via SAN. 3. Install PostgreSQL and be sure PGDATA is on the cfs mount 4. Create a Storage Checkpoint of cfs mount (read-write virtual copy) 5. Bring up PostgreSQL on node1 6. Mount storage checkpoint on node2 7. Start PostgreSQL on node2 Drawbacks? Heck yes. There are many and you should understand the nature of Veritas Storage Checkpoints before using. I have tested it though in conjunction with dblink() and some other proprietary API's we use for load balancing and the potential is there to manage many large SELECT's. Greg -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Chris Browne Sent: Tuesday, September 20, 2005 10:15 PM To: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: postgresql cluster on SAN 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
