Ir al contenido
Se marcó esta pregunta
backup12.0
2 Respuestas
6895 Vistas
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
Descartar
Avatar
Emmanuel Belair
Autor Mejor respuesta

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
Descartar
Avatar
Badr Elboudour Zahmoul
Mejor respuesta

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
Descartar
jiju sebastian

This page is not available

Publicaciones relacionadas Respuestas Vistas Actividad
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 Resuelto
backup
Avatar
Avatar
Avatar
Avatar
Avatar
9
jul 25
67741
How To Set Char Type Field Only Have Number Input ODOO 12 ?
12.0
Avatar
2
ene 25
7694
how to backup ? Resuelto
backup
Avatar
Avatar
Avatar
Avatar
Avatar
9
jul 24
104427
computed fields Resuelto
12.0
Avatar
Avatar
1
abr 24
3670
backup error
error backup odoo 12.0
Avatar
Avatar
Avatar
2
ene 24
7667