Thanks. To be clear, here's a snippet of a working mixed-db config,
with the pools renamed more logically. ("main", "log", "subquery"
have no relation to their use any more).
ns_section "ns/db/pools"
ns_param oacs_1 "OpenACS.org depth 1 pool"
ns_param oacs_2 "OpenACS.org depth 2 pool"
ns_param oacs_3 "OpenACS.org depth 3 pool"
ns_param other "Some Other DB Pool"
ns_section "ns/server/${server}/acs/database"
ns_param AvailablePool "oacs_1"
ns_param AvailablePool "oacs_2"
ns_param AvailablePool "oacs_3"
But then make sure you rename each ns/db/pool/[poolname] section!
Oh, and indeed you could do it on the fly, but then you'd have to
do it every time before every use, so that it survived restarts.
