Odoo Help


separation of postgres database in two difference server.

on 4/29/15, 8:33 AM 2,071 views

Anyone explain how can do the  separation of postgres database into sensitive data and secure data sections both these sections in two different servers.

Michael Thomas
On 4/29/15, 9:27 AM

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. 

Ralph LAvaud
On 4/30/15, 2:28 PM

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

On 4/30/15, 3:22 AM

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.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 4/29/15, 8:33 AM
Seen: 2071 times
Last updated: 4/30/15, 2:28 PM