@skotl said:And, much as I hate Oracle (the company and the products), I still maintain that if you want a multi-active-node, HA, load-balanced, sure-you-can-have-a-lazy-write-instance-for-reporting RDBMS solution, then Oracle RAC is it.
Funny thing that the one time when I was at a place that was looking into that kind of thing, when we showed our requisites to a vendor the replay was "no, you can't do that with Oracle, in fact you can't do that with any [relational] database". That, and a following discussion about the meaning of the word "active".
Later that same day I tryed researching it, and yep, Postgres could do all that. But that was by 2007, maybe Oracle did improve by now.
Oracle RAC was introduced with version 9i around 2001. I'm not aware that postgres allows for a "shared everything" cluster architecture. Maybe your requisites required some other features?