If you want odoo on one server and your database on another, see this guide:
If you want to split the postgreSQL database itself, that sounds like a huge can of worms. You would have to modify the core system files. You could write your own library for handling some of your data and have it connect to a different server and execute sql on that, but sounds pretty terrible to me. Ultimately, odoo is not made to run on 2 seperate databases on 2 different servers. Making this work would be such a challenge, it would probably be better to start from scratch.
That said, I can't imagine what you want to divide into secure and unsecure. Your entire database should be hosted in a secure environment. You have all the tools in odoo to control what rights users have and can secure area's they should not be accessing.
what constitute secure vs un-secure data? This seems to be more related with giving certain access to users depending on where they are connecting from
If you want to provide some readonly access to some data to some external users this can be accomplished with the portal or a custom module
Again what is secure and what is un-secure? Further more regardless of secure access or not, the db server should be in a deep layer behind your firewall
Actually this solution required for client , they needs secure database should be accessible in secure environment which the access from outside and other one working as non secure environment, like they access this database intranet with in the Premises. so what solution we suggest them.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/29/15, 8:33 AM|
|Seen: 826 times|
|Last updated: 4/30/15, 2:28 PM|