Odoo Help


This community 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.


separation of postgres database in two difference server.

on 4/29/15, 8:33 AM 676 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.

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


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