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.


Transaction management during failover

Mantavya Gajjar (mga)
on 2/11/13, 7:49 AM 1,683 views

Does any one have configured failover server for OpenERP as an application server and/or PostgreSQL as a database server ?

Is it possible to spread postgres database across more than 1 partition (Raid4 partition) and then set up a failover server so, if the main server crashes in middle of the transaction, then the transaction will complete in the failover server.

Similar case for OpenERP Server, If the openerp server crashes, is there a possibility to setup a failover instance that would immediately take over the original instance and continue with the transactions?


Since the version 6.1 of OpenERP, the cache is in the database, so you can configure a reverse proxy to serve two openerp servers.

If the first one crashes, you will have the second.

About the database, you can use pgpool2 for the replication and the load-balancing and it manage the fail-over.

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: 2/11/13, 7:49 AM
Seen: 1683 times
Last updated: 3/16/15, 8:10 AM