Anyone explain how can do the separation of postgres database into sensitive data and secure data sections both these sections in two different servers.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
If you want odoo on one server and your database on another, see this guide:
http://toolkt.com/site/install-openerp-server-and-postgresql-on-separate-servers/
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.