On Tue, 2006-03-07 at 13:00 -0600, Jim C. Nasby wrote: ...
> PostgreSQL on a SAN won't buy you what I think you think it will. It's > essentially impossible to safely run two PostgreSQL installs off the > same data files without destroying your data. What a SAN can buy you is > disk-level replication, but I've no experience with that. It is possible to run two instances against the same SAN using tools such as RedHat's Cluster Suite. We use that in-house as a cheap alternative for Oracle clustering, although we're not using it for our PostgreSQL servers yet. It's not for load balancing, just active/passive fault tolerance. -- Mark Lewis ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
