How to Restore a Database in Odoo18 ERP

Technical Guide, Odoo18

Introduction 

Maintaining data consistency and managing databases well is essential in Odoo ERP. With Odoo18, improvements in the user interface and security bring changes to how database operations are done. In this guide we will look at how to restore a database in Odoo18, from the web interface and the terminal (psql), and also give you the latest advices, best practices and security advice.

I. Backup Database in Odoo18

Just make a backup before restoring just in case you loose anything. In Odoo18 there are 2 methods of making back-ups that both work; through the web-interface and with the CLI.

A. Inconsistencies in the Odoo18 Interface

Go to: 

http://<your-odoo-domain>/web/database/manager 

Click on the “Backup” button. 

Enter the master password that you chose in your first Odoo installation.

Choose a format: 

– ZIP file: Includes filestore, dump.sql, and manifest.json. 

– pg_dump (.dump format): Does not include filestore, this format is faster and is preferred for large databases.

Click “Backup” to save to the archive.

Odoo18 Update: 

The Database Manager UI gets some improved error messages and file-upload validation.

You can now view active sessions prior to a backup. This prevents you from restoring into an in-use environment.

II. Restore Database in Odoo18 

There are two main methods: 

A. Recover with the Hidive from Odoo18 Interface

Visit: 

http://<your-odoo-domain>/web/database/manager 

Click “Restore Database.” 

Provide the master password. 

Click “Upload Backup File” and select the .zip file with your backup. 

Enter a new database name. It must be unique. 

Click Continue to proceed with the restoration.

B. Restore Using Terminal (PostgreSQL PSQL Method) 

This is preferred for:

• Large databases
• Remote servers 
• Automated deployments 

Step-by-step: 

1 . Extract the .zip backup: 

2 . Login to PostgreSQL and create the database:

3. Restore the dump

4. Move the filestore:

 If using the filestore, move it to the correct location:

Odoo18 Updates:

• Odoo now auto-validates manifest.json and warns if incompatible version or modules are found.
• pg_restore is recommended for .dump files:

III. Restore with Dockerized Odoo18 (New Method)

If you’re using Docker containers for Odoo18:

To restore filestore:

IV. Best Practices (New for Odoo18)

• Enable database restore access only for administrators.
• Validate database version compatibility before restore.
• Do not restore into a running production database.
• Always perform the restore in a staging environment first to ensure everything works correctly.
• Use .dump format for faster restoration via CLI.

Odoo18 continues to enhance database management with improved UI, safer restore logic, and Docker compatibility. Whether you’re using the interface or command-line tools, following the correct steps ensures data safety and system integrity. With these new features and procedures, database restoration is smoother, faster, and more secure in Odoo18 ERP.