Forum OpenACS Q&A: Response to Postgres, distributed databases, two phase commits, or other replication strategies....

Jerry,

I don't know much about Postgres, but we are using Oracle effectively with EMC disk array to create what they call BCV (Business Control Volume) of PROD i.e. multiple copies of PROD for different purposes like reporting, backup etc on different locations. This is what you call disk replication but how this is affecting the licensing?
We are using a combination of BCV and materialized views to have the updated PROD available almost on real time basis.. but I think you may also want to seriously look at OPS  if you are beyond 8.1.6..