Hi everyone 👋
I work with Odoo 17 Enterprise (SH) at my company, but I’ve also set up a self-hosted Odoo 18 CE on a VPS for development and module testing — plus a small homelab for experiments.
I’m not a server expert (I build our company websites myself), so Docker, Traefik, and Linux permissions are still quite new to me.
My goal is simple:
Create a reproducible backup of my live Odoo instance (DB + filestore + config) and restore it as a working “staging” copy on the same VPS.
I’ve already tried using pg_dump / pg_restore and rsync for the filestore, but every attempt ends up with broken permissions, authentication issues, or Odoo failing to start or log in properly.
Even when the containers look healthy, the staging copy won’t connect correctly to the cloned database.
I’d really appreciate a verified best practice or step-by-step workflow for:
- Exporting DB + filestore safely from a running Docker-based Odoo (18.0 + PostgreSQL 16)
- Restoring it into a staging environment on the same VPS
- Avoiding permission mismatches or XMLID conflicts after cloning
Any help, experience, or documentation links would be amazing — I just want a stable, testable backup & restore setup before going full production.
Thanks a lot for your time
— Angel
"Odoo 18.0 CE" is not a question. A question is a substantial phrase that ends with "?"
We get close to 1,000 posts a month and not everyone will open a post to find out what your question is.
I have edited your post to make the title a question.
In the future, please consider (1) using a Question that makes it clear what you ask without requiring people to open your post and (2) adding Tags. This will often increase the chances people will respond and also make everything clearer for others who may come along later searching for the same thing.
Failing that, you can paste your future posts into an AI Chatbot and ask it to "please generate a question of no more than 16 words that summarizes what I am asking" and use that as your question.
See also https://www.odoo.com/forum/help-1/meta-why-do-some-questions-get-answers-and-others-do-not-25620