This question has been flagged
2 Replies
5526 Views
backup12.0
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