Hello everyone,

I have a problem with my Odoo installation.

I have built an Odoo 14 in a set of Docker containers (an Odoo container and a Postgres container in version 10.3). Everything seems to work fine.

I tried to create a new database from the Odoo web interface and all went well. The database was created in the postgres container and the filestore directory was created in the odoo container (in /var/lib/odoo/filestore).

In the same Odoo installation, I tried to restore an existing database using the ZIP archive containing the database dump and filestore directory and, although the database was created in the postgres container, the filestore directory was not created in the odoo container at all.

Has anyone ever encountered this phenomenon?

I've already checked the filestore directory (/var/lib/odoo) permissions and I've also checked postgres versions (psql, pg_dump and pg_restore are all in version 10.3). 

The restored database was originally created with postgresql 10.3 as well.

I get no errors in the logs (neither Odoo nor postgres) when I try to restore the database.

On the other hand, I tried to dump the database I created directly from the web interface and got this error in the Odoo logs:

2024-01-25 14:19:45,357 9 INFO ? odoo.service.db: DUMP DB: odoo format zip 

2024-01-25 14:19:45,578 9 ERROR ? odoo.addons.web.controllers.main: Database.backup 

Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1180, in backup

    dump_stream = odoo.service.db.dump_db(name, None, backup_format)

  File "", line 2, in dump_db

  File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 41, in if_db_mgt_enabled

    return method(self, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 241, in dump_db

    odoo.tools.exec_pg_command(*cmd)

  File "/usr/lib/python3/dist-packages/odoo/tools/misc.py", line 130, in exec_pg_command

    raise Exception('Postgres subprocess %s error %s' % (args2, rc))

Exception: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpok49pnxc/dump.sql', 'odoo') error 1

There's definitely a configuration problem somewhere, but I can't put my finger on it. Does anyone have any ideas?

Thank you in advance