Database Auto-Backup fails on pg_dump error about server-tools HOT 6 OPEN

same happens without this module, resolve it by installing postgres specific client version in odoo container:
instead of postgresql-client use: postgresql-client-13 and all should be good

from server-tools.

I think this is PostgreSQL >= 16 related, since I encounter this issue on all the servers where PostgreSQL 15 -> 16 db upgrade was performed.
It concerns this module since pg_dump --no-owner -d dbname > date_in_yyyy-mm-dd.dump.sql works fine from command line, but not directly since the problem starts with dump_db method from base odoo db.py service file.

It seems that my case confirms [this issue](TRESCLOUD/odoo@977fe3b effects also raw OS and is related to the pg_dump versions > 16.1.

from server-tools.

@claudiobgit did my answer resolve the issue? can you mark it resovled and close or do you still face the same problem?

from server-tools.

@claudiobgit did my answer resolve the issue? can you mark it resovled and close or do you still face the same problem?

I didn't want to mess with the db client on the Odoo server and properly install postgresql-client-13 in the odoo container (Debian buster) as it could be critical for other services. So I ended up with a cron job that executes the pg_dump command from the Odoo container and that works perfectly. We can close this issue but not really solved.

from server-tools.

FYI.... for odoo 14 suggested postgresql version is 12... and that one works without prolem..
offcourse, newver versions of psql will work with respectful clients installed :)

from server-tools.

FYI.... for odoo 14 suggested postgresql version is 12...

This sounds new because we were getting Odoo official images from the hub and the Docker compose yaml was taking in Postgres 13 not 12.

from server-tools.