October DealsAmazon USOctober deal check: compare before you payAmazon US: current deals, useful picks and tech finds.Check DealsWindows FixRecommendedWindows errors stealing your time? Find the fix fastScan stability, cleanup and performance issues.Fix NowOctober DealsAmazon USDeal season is back - check today's better picksAmazon US: current deals, useful picks and tech finds.See Picks×
Skip to content
World desk4 min

How to Back Up and Restore a Self-Hosted Odoo Database

A safe self-hosted Odoo recovery plan pairs the PostgreSQL backup with its matching filestore, stores a copy away from production, and tests restoration on an isolated instance.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

A reliable self-hosted Odoo backup must preserve PostgreSQL data and its matching filestore together, with at least one copy stored away from the production server. Restore that pair first in an isolated test database or recovery instance, and verify the commands and paths for your Odoo version and installation type before touching production.

What an Odoo backup must contain

Odoo stores business records in PostgreSQL, while uploaded documents and other file-backed content are stored in the filestore. A database dump without its matching filestore may leave records present but attachments unavailable. Odoo’s deployment guidance recommends backing up the database and filestore together; its Odoo 19 on-premise backup route offers ZIP format that includes the filestore. Odoo 19: Importing a database · Odoo 14: System configuration

As an Amazon Associate I earn from qualifying purchases.

Keep the database dump and its corresponding files as one recovery set. If you use separate tools or destinations, record which filestore belongs with which database backup; combining files from different backup points risks missing or inconsistent attachments.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Create a backup

Download a ZIP through the Database Manager

Odoo 19 documents this on-premise download route in guidance for importing databases into Odoo.sh. It establishes the archive steps, but does not mean Odoo.sh is self-hosted.

#1 Best Overall
Sale
Seagate 2TB Portable Hard Drive | USB 3.0 (STGX2000400)
  • Easily store and access 2TB to content on the go with the Seagate Portable Drive, a USB external hard drive
  • Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
  • To get set up, connect the portable hard drive to a computer for automatic recognition no software required
  • This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
  • The available storage capacity may vary.
  1. Open /web/database/manager on the Odoo instance.
  2. Choose Backup, select ZIP so the archive includes the filestore, and provide the server master password if prompted.
  3. Save the archive somewhere other than the production host and confirm that the downloaded file is intact.

The manager may be unavailable if an administrator has disabled it. Odoo warns that the Database Manager is not designed for production use or large databases, and recommends disabling it on internet-facing systems. Its deployment guidance says production database-management operations should be performed by the system administrator. For those environments, use an administrator-managed backup process rather than exposing the manager as a routine public-facing tool. Odoo 19: Importing a database · Odoo 14: System configuration

Use the command line where it fits your deployment

Odoo 19’s CLI reference documents ZIP and pg_dump backup formats and the database-load pattern odoo-bin db load <database> <dump_file>. A source installation uses ./odoo-bin; a distribution-package installation adds an odoo command. With Docker, adapt the command for the container. The reference also describes database duplication including the filestore, which can help create a test copy. Executable names, paths, and options vary by release and installation, so check the documentation for the deployed version before using a command. Odoo 19 CLI reference

Rank #2
YOTUO 500GB External Hard Drive, Portable Storage Expansion HDD, USB 3.0 & USB-C for PC, Mac, Desktop, Laptop, Smartphone, PS4, Xbox One, Xbox 360, Office & Game Black
  • 【Versatile Storage Expansion – For Gaming, Work & Everyday Use】 Running out of space on your PS5 or Xbox Series X/S? This external hard drive lets you store and play PS4 / Xbox One games directly, instantly freeing up your console’s internal storage for next‑gen titles. At the same time, it handles work file backups, media libraries, and cross‑device data transfers with ease. One drive, all your needs. *(Note: PS5 / Xbox Series X|S games cannot be run or stored directly from the external hard drive. However, by offloading your PS4 / Xbox One games, you can free up valuable space for newer titles.)*
  • 【Patented Silicone Sleeve – Data Protection You Can Count On】 Worried about drops? We’ve got you covered. The patented built‑in silicone sleeve acts like a shock‑absorbing armor, cushioning your drive against bumps and falls. Whether it’s important work documents, precious family photos, or hard‑earned game saves, your data deserves this level of protection.
  • 【Plug & Play, Compatible with Computers & Consoles】 No complicated setup—just plug in and go. Works seamlessly with Windows, Mac, and Linux computers, as well as PS4, PS5, Xbox One, and Xbox Series X/S. Process files at the office, back up data at home, or enjoy gaming in your downtime—one drive handles all your devices, simply and hassle‑free.
  • 【USB 3.0 Ultra‑Fast Transfer – No More Waiting】 Tired of watching progress bars crawl? With USB 3.0 speeds up to 5Gbps, large files transfer in seconds. Whether you’re moving work documents, transferring hundreds of gigs of games, or backing up a year’s worth of photos, you get more done in less time.
  • 【Sleek, Lightweight, and Ready to Go】 Weighing just 0.16 kg—lighter than a can of soda—this compact drive features a stylish mirror‑and‑frosted finish. Toss it in your bag and go, whether you’re heading to the office, visiting a friend for a gaming session, or giving a presentation on the road.

Store backups for recovery, not just convenience

Odoo’s deployment guidance recommends daily backups of both database and filestore data, with a copy sent to a remote archive server that the Odoo server itself cannot access. That separation matters: a backup kept only on the production host can be lost along with it. An offline removable drive can be an additional copy, but it should not be the only off-host protection if it is routinely connected to the same machine.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Take a fresh full backup before upgrades or other risky maintenance. Odoo 19’s update guidance recommends storing that backup safely on a different computer. The cited recommendation does not establish a self-hosted retention period; choose one that fits your recovery needs and storage capacity. Odoo 14: System configuration · Odoo 19: Bugfix updates

Rank #3
Sale
Sandisk 1TB Portable Drive, Up to 600MB/s Read Speeds - Black
  • Up to 4x faster transfer speeds than old-school portable hard drives(3) - skip the wait when moving large files with up to 600MB/s(2) read speeds.​
  • Durable design - no moving parts means better durability with up to 2-meter drop protection(4).
  • POCKET-SIZED – fits easily in pockets and small bags.
  • Space to own your AI content – fast storage to quickly download your AI edits, clips, and files.
  • USB-C ready - plug in and get to work instantly.

Do not assume Odoo.sh’s managed backup or retention behavior applies to a self-managed server. Odoo.sh describes platform-specific backups and warns that importing into an existing branch overwrites its data; those rules are not defaults for self-hosted Odoo. Odoo.sh: Branches

Restore safely to a test instance first

There is no single restore command that is safe to copy unchanged across every self-hosted Odoo setup. Before restoring, identify the Odoo major version, source/package/Docker installation, PostgreSQL location and credentials, target database name, and Odoo data directory. The data directory contains items such as the filestore and sessions, and the CLI’s command and paths depend on installation type.

Rank #4
Ezekers Portable 500GB External Hard Drive - USB 3.0 & USB C for PC, Mac, PS5 (Storage Only), PS4, Phone (Android and iPhone 15/16/17) & Xbox - Ultra Fast
  • Storage Capacity: 500 GB (gigabyte) of storage space.
  • Compact Size: 2.5-inch form factor for portability.
  • Multi-Platform Compatibility: Works seamlessly with PS4, Mac, phones (Andriods with USB C), and Xbox devices.
  • High-Speed Data Transfer: USB 3.0/C for fast data transfer speeds.
  • Sleek Design: Stylish and durable casing.
  1. Choose an isolated target. Use a separate test database or recovery instance rather than overwriting production. Odoo’s CLI documentation describes duplication including the filestore as one way to create a test copy.
  2. Match the backup pair. Confirm that the archive includes the filestore or that you have the corresponding filestore saved separately from the same backup point as the database.
  3. Check the installed-version instructions. For Odoo 19, the documented load pattern is odoo-bin db load <database> <dump_file>, but the executable and paths must be adapted for source, package, or Docker deployment. The supported dump file may be ZIP or pg_dump. Do not run the source-install example unchanged on another installation type.
  4. Validate the recovered data. Confirm the restored database opens under a compatible Odoo version and inspect records with attachments or other file-backed content to ensure files are accessible.
  5. Record the procedure. Note how the backup was created, the location of its matching filestore, and the restore steps used. Repeat test restores periodically to establish that the recovery set and instructions still work.

The documentation supports paired database-and-filestore handling, but does not prescribe a universal validation checklist for every customized deployment. Tailor the checks to the modules and workflows your organization depends on. Odoo 19 CLI reference · Odoo 19: Importing a database

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Before restoring on production

  • Confirm you have the intended database backup and its matching filestore, not files from a different backup point.
  • Verify the Odoo version, database target, PostgreSQL access, executable, and data-directory paths against your actual installation.
  • Test the recovery on an isolated instance first whenever possible, including access to attachments.
  • Keep the off-host backup protected from access by the production server itself.
  • Before upgrades or other changes, take a fresh full backup and store it on a different computer.

Odoo does not publish a universal self-hosted restore-success statistic or one retention policy for all deployments. Its Odoo.sh retention and managed-backup details describe that hosted platform, not your own server.

Quick Recap

SaleBestseller No. 1
Seagate 2TB Portable Hard Drive | USB 3.0 (STGX2000400)
Seagate 2TB Portable Hard Drive | USB 3.0 (STGX2000400)
This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable; The available storage capacity may vary.
$129.99
SaleBestseller No. 3
Sandisk 1TB Portable Drive, Up to 600MB/s Read Speeds - Black
Sandisk 1TB Portable Drive, Up to 600MB/s Read Speeds - Black
POCKET-SIZED – fits easily in pockets and small bags.; USB-C ready - plug in and get to work instantly.
$129.99
Bestseller No. 4
Ezekers Portable 500GB External Hard Drive - USB 3.0 & USB C for PC, Mac, PS5 (Storage Only), PS4, Phone (Android and iPhone 15/16/17) & Xbox - Ultra Fast
Ezekers Portable 500GB External Hard Drive - USB 3.0 & USB C for PC, Mac, PS5 (Storage Only), PS4, Phone (Android and iPhone 15/16/17) & Xbox - Ultra Fast
Storage Capacity: 500 GB (gigabyte) of storage space.; Compact Size: 2.5-inch form factor for portability.
$34.99
Best Value
YOTUO 1TB External Hard Drive, Portable Storage Expansion HDD, USB 3.0 & USB-C for PC, Mac, Desktop, Laptop, Smartphone, PS4, Xbox One, Xbox 360, Office & Game, Black
  • 【Versatile Storage Expansion – For Gaming, Work & Everyday Use】 Running out of space on your PS5 or Xbox Series X/S? This external hard drive lets you store and play PS4 / Xbox One games directly, instantly freeing up your console’s internal storage for next‑gen titles. At the same time, it handles work file backups, media libraries, and cross‑device data transfers with ease. One drive, all your needs. *(Note: PS5 / Xbox Series X|S games cannot be run or stored directly from the external hard drive. However, by offloading your PS4 / Xbox One games, you can free up valuable space for newer titles.)*
  • 【Patented Silicone Sleeve – Data Protection You Can Count On】 Worried about drops? We’ve got you covered. The patented built‑in silicone sleeve acts like a shock‑absorbing armor, cushioning your drive against bumps and falls. Whether it’s important work documents, precious family photos, or hard‑earned game saves, your data deserves this level of protection.
  • 【Plug & Play, Compatible with Computers & Consoles】 No complicated setup—just plug in and go. Works seamlessly with Windows, Mac, and Linux computers, as well as PS4, PS5, Xbox One, and Xbox Series X/S. Process files at the office, back up data at home, or enjoy gaming in your downtime—one drive handles all your devices, simply and hassle‑free.
  • 【USB 3.0 Ultra‑Fast Transfer – No More Waiting】 Tired of watching progress bars crawl? With USB 3.0 speeds up to 5Gbps, large files transfer in seconds. Whether you’re moving work documents, transferring hundreds of gigs of games, or backing up a year’s worth of photos, you get more done in less time.
  • 【Sleek, Lightweight, and Ready to Go】 Weighing just 0.16 kg—lighter than a can of soda—this compact drive features a stylish mirror‑and‑frosted finish. Toss it in your bag and go, whether you’re heading to the office, visiting a friend for a gaming session, or giving a presentation on the road.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

More from the Wire

  1. World desk4 min
    How to Spot an AI Voice Scam Before Sending MoneyDon’t rely on how a caller sounds. Pause, call back through a known number, and verify the emergency with another trusted person before sending money.
  2. Mountain View desk4 min
    Google’s SynthID Detector: How to Check AI-Generated Images, Video and AudioGoogle’s SynthID Detector looks for an embedded watermark in supported images, video and audio. Here is what its results do—and do not—show.
  3. Redmond desk20 min
    How to create a link to File or Folder in Windows 11Windows 11 gives you several ways to point to a file or folder without moving or duplicating it. You can create a desktop shortcut,…
Recommended PC Tool
Recommended PC Tool
Crashes, No Sound, or Screen Glitches?Free driver scan
Windows Errors? Fix Them Before They SpreadFree repair scan

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.