This question has been flagged
1 Reply
2115 Views

Hello Experts

I'm facing a error while executing database backup with filestore at /database/manager. This is the error:


2021-06-25 14:36:27,815 2221 ERROR databaselive odoo.addons.web.controllers.main: Database.backup
Traceback (most recent call last):
File "/odoo/odoo-server/addons/web/controllers/main.py", line 1151, in backup
dump_stream = odoo.service.db.dump_db(name, None, backup_format)
File "", line 2, in dump_db
File "/odoo/odoo-server/odoo/service/db.py", line 40, in if_db_mgt_enabled
return method(self, *args, **kwargs)
File "/odoo/odoo-server/odoo/service/db.py", line 228, in dump_db
odoo.tools.exec_pg_command(*cmd)
File "/odoo/odoo-server/odoo/tools/misc.py", line 132, in exec_pg_command
raise Exception('Postgres subprocess %s error %s' % (args2, rc))
Exception: Postgres subprocess ('/opt/rh/rh-postgresql10/root/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpys4s_xjs/dump.sql', 'databaselive') error 127
2021-06-25 14:36:27,917 2221 INFO databaselive werkzeug: 109.164.242.121 - - [25/Jun/2021 14:36:27] "POST /web/database/backup HTTP/1.0" 200 - 26 0.032 2.867


Note: I can create backups with dump format (without filestore)


can someone help with this error?


Avatar
Discard
Best Answer

Hi,

Upgrade your pg_dump version to match your PostgreSQL server version.

1. logging to postgresql


    sudo su - postgres

    -bash-4.2$ pg_dump od15_br220805 | gzip > od15_br220805.gz
    pg_dump: server version: 13.9; pg_dump version: 9.2.24
    pg_dump: aborting because of server version mismatch
    -bash-4.2$ exit

    ##so obviously is the pg_dump version not matched to the server version

2. change the pg_dump version

   pg_dump --version

       ## pg_dump (PostgreSQL)9.2##

   sudo find / -name pg_dump

        ## /usr/bin/pg_dump ##
        ## /usr/pgsql-13/bin/pg_dump ##

    sudo ln -sfn /usr/pgsql-13/bin/pg_dump /usr/bin/pg_dump

    pg_dump --version

        ## pg_dump (PostgreSQL) 13.9 ##


Hope it helps

Avatar
Discard