Skip to Content
This question has been flagged
backup12.0
2 Replies
5687 Views
Avatar
Emmanuel Belair

Hi, on a fresh odoo 12 install, I try to backup the database with filerestore but I get the following error:

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

I'm using odoo 12 on a docker container (installed using the official docker image & doc https://hub.docker.com/_/odoo )

I'm answering here because of not enough karma...

I did not modify the database schema

I use the postgres:10 docker image that contains the client natively

EDIT: Note that if I choose the dump method, I get this error from the standard output :

2019-01-08 16:06:03,107 1 INFO odoo odoo.service.db: DUMP DB: odoo format dump
pg_dump: server version: 10.6 (Debian 10.6-1.pgdg90+1); pg_dump version: 9.6.10
pg_dump: aborting because of server version mismatch
Avatar
Discard
Avatar
Emmanuel Belair
Author Best Answer

Finally, I found the problem. Odoo 12 docker instance use the postgresql 9.6 client, but the pg container need v10

So it's a bug of the Docker v12 image. See https://github.com/odoo/docker/issues/234

I've edited the Dockerfile then install pg10 client and now it's working:

https://github.com/odoo/docker/blob/520ab50bb08654c52b1122893d9729a745c48c0a/12.0/Dockerfile#L30


Avatar
Discard
Avatar
Badr Elboudour Zahmoul
Best Answer

Hello, did you check these previous posts?
https://www.odoo.com/forum/help-1/question/database-backup-error-postgres-subprocess-usr-bin-pg-dump-no-owner-file-tmp-tmpaa0o5q-dump-sql-u-ahlain-db01-error-1-118245
https://github.com/Yenthe666/auto_backup/issues/78

Avatar
Discard
jiju sebastian

This page is not available

Related Posts Replies Views Activity
how to backup ? Solved
backup
Avatar
Avatar
Avatar
Avatar
Avatar
9
Jul 24
87665
computed fields Solved
12.0
Avatar
Avatar
1
Apr 24
1474
backup error
error backup odoo 12.0
Avatar
Avatar
Avatar
2
Jan 24
5337
running odoo 12 on ubuntu 22.04 OS, python 3.7, postgresql 15.0
12.0
Avatar
Avatar
1
Dec 23
2746
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 Solved
backup
Avatar
Avatar
Avatar
Avatar
Avatar
9
Dec 22
59220