We (furfly) plan to offer this; unfortunately it keeps getting pushed back due to client work and I've given up trying to estimate when it will actually launch. It is in the works, however!
Our intention is to allow each user to install their own copy of OpenACS; it can't work any other way. There will be only one Postgres installation, though, and each person will have their own login.
