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!