Skip to Content
Menu
This question has been flagged
1 Reply
265 Views

Hello everyone,

I'm facing an issue while backing up a database in Odoo 18 with PostgreSQL 16.

When I try to back up the database with filestore enabled, I get the following error:


Database backup error: Command '['/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpcqopcknp/dump.sql', 'DBNAME']' returned non-zero exit status 1.  


However, if I back up the database without the filestore, the backup completes. But when I try to restore it locally, the restored database seems corrupted or incomplete.  


Notes:   The database was migrated by importing data via XML-RPC, not by direct pg_dump or upgrade,  I have checked roles and PostgreSQL installation, and only PostgreSQL 16 is installed, Odoo 18 is running from source (GitHub version)  

Has anyone faced a similar issue or has advice on how to solve this?

Any help would be appreciated!

Avatar
Discard
Author Best Answer

I changed the /tmp mount point from a tmpfs to a regular disk-backed directory with more space. After doing that, the database backup with filestore enabled worked without issues.  

Avatar
Discard
Related Posts Replies Views Activity
1
Dec 21
9667
1
Mar 15
3482
3
Jul 24
5461
0
Mar 23
1548
1
May 21
3326