Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
1 Antworten
936 Ansichten

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
Verwerfen
Autor Beste Antwort

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
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
1
Dez. 21
10326
1
März 15
3904
3
Juli 24
6969
0
März 23
2133
1
Mai 21
3992