Forum OpenACS Q&A: Re: multi-db and -dbn

Collapse
3: Re: multi-db and -dbn (response to 1)
Posted by Andrew Piskorski on
I recomend naming your pools to indicate which db they below to, e.g. "pg_pool_1". It's not strictly necessary but helps keep things clear.

If you want to use the multi-db support you should not be using the "availablepool" syntax, it is there only for backwards compatibility. So you are both correct to levae those availablepool lines out.

I don't know what the problem is, your config files look ok to me. I haven't touched or looked at any of that code since April 2003 though, so it's possible somebody broke it since then. Unfortunately I don't currently have Oracle and PostgreSQL set up for testing, so I can't test it myself right now.

What specific release of OpenACS are you using, the OpenACS 5.0.0b4 tarball? The multi-db stuff should work in all OpenACS 5.x versions, but like I said I haven't actually tested it for many months...