Forum OpenACS Development: Re: OpenACS 5.9.0 , Postgresql 9.4, and Naviserver 4.99
4: Re: OpenACS 5.9.0 , Postgresql 9.4, and Naviserver 4.99 (response to 3)
Posted by Gustaf Neumann on 03/24/16 04:12 PM
The decision about using separate databases was done before i got involved with OpenACS. Probably at that time the support for multiple schemata in oracle/pg was bad/not existing, so using different dbs for different instances was a no-brainer. The biggest advantage of the multiple schema approach is imho referential integrity across instances, which is not needed for OpenACS.
Separate dbs makes it easier to migrate/upgrade/save one instance, the security separation is easier, etc. but altogether the pros/cons are somewhat even (see e.g. )
5: Re: OpenACS 5.9.0 , Postgresql 9.4, and Naviserver 4.99 (response to 4)
Posted by Khy Huang on 03/24/16 05:05 PM