Odoo Help


1 答案

Yenthe Van Ginneken 比利时

--Yenthe Van Ginneken--
| 9 9 12
Turnhout, 比利时
--Yenthe Van Ginneken--

My Odoo training platform: https://www.oocademy.com
My Odoo blog: http://www.odoo.yenthevg.com/
My Twitter: https://twitter.com/Yenthe666

Yenthe Van Ginneken 比利时
2019/1/21 上午4:17

Hi Donald,

The easiest to do is by setting up a clean new server. Install Odoo on it with the latest patches, install postgreSQL and then manually move the database. If the database is not huge you can take a backup through the frontend on http://yourwebsite.com/web/database/manager as this will include all images into the dump file.
If the database is to big you'll need to dump it from the command line. In this case you will need to restore the database on the new instance and also move the filestore (which holds all your files) manually to the new server.
One of the guys on the help forum has made a post about this which explains it quite well. See https://www.odoo.com/nl_NL/forum/help-1/question/odoo-10-backup-and-restore-123954  
In essence you do the following:

# On the old server:
pg_dump --format=c dbname > dbdump.dump
# On the new server (under the postgreSQL user):
createdb upgraded_dbname
pg_restore -O -x -d upgraded_dbname < upgraded_dbdump.dump


2 注释
Donald Leaman 美国
2019/1/21 下午3:28

I didn't read the other post yet, but to clarify, I got us a new server. I want to keep the Odoo app on the computer where it is now, but I want to move the database server to my new server. So, let me see if I got this right: 1.) I install PostgreSQL on my new server. 2.) I back up my database from where it is now. 3.) I recover that backup to the PostgreSQL that I installed on my new server. 4.) I configure Odoo, on the computer where it currently resides, with the IPnn.nn.nn.nn:port5432 of my new PostgreSQL location. I could even use pgAdmin that's on the computer where my current Odoo and PostgreSQL reside as an admin tool for the PostgreSQL at the new location. I just don't see how to configure Odoo for where to connect to PostgreSQL.

Donald Leaman 美国
2019/1/22 上午11:28

OK, one more question: How do you configure PostGreSQL to specify where the data store should be located other than the default?

Keep Informed
1 关注者(s)
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