you can play around with my first efforts to get auto-configuration
If you configure your OpenNSD acs.tcl script to use a series of
PostgreSQL database pools and fire up this version of OpenACS 4x, it
will tell you your PostgreSQL driver's correctly configured (assuming
you're running PG 7.1, you'll get an error otherwise) and offer you a
"Next" button. Press it and it will load the PG acs-kernel datamodel
Dan's created over the past couple of weeks.
At the end it will die because the code will try to feed PG an Oracle
query, but it *does* succeed in loading the acs-kernel datamodel.
If you then reconfigure your acs.tcl file to define Oracle pools, it
will load the Oracle acs-kernel datamodel. This works, i.e. I've
tested and you can continue forth and complete your installation to
the bitter end (and when you do a "drop user foo cascade" afterwards
in preparation for your next round of testing, you'll understand why
it's a bitter end - it takes Oracle a long time to get rid of the
installation, at least on my laptop).
I'll post momentarily on the next steps that need to happen, and
tomorrow I'll post more in regard to thoughts about how to get folks
busy working on the project sooner rather than later.