Error Restoring database

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Comptabilité
Inventaire
PoS
Project
MRP

All apps

Toutes les publications Personnes Badges

Étiquettes (Voir toutl)

odoo accounting v14 pos v15

À propos de ce forum

Aide

Error Restoring database

v8 postgresql backup

1 Répondre

25731 Vues

Shawn Varghese

I have used a script to backup my databases, and obtain a .sql.gz file as the backup file.

However, when I try to restore this file, I get the following error:

Exception: Postgres subprocess ('/usr/bin/pg_restore', '--username=odoo', u'--dbname=test1', '--no-owner', '/tmp/tmp2gZGZu') error 1

Could someone please help resolve this? All my backups are worthless as they throw the same error while restoring.

Kinner Vachhani

Meilleure réponse

Hey Shawn,

I am not sure how you are restoring the db. But I follow below steps

$createdb test1 -T template1 -U odoo -h localhost

$zless test1.sql.gz | psql test1

Dumps:

$pg_dump --no-owner test1 | gzip > test1.sql.gz

Shawn Varghese

Auteur

Thanks a lot Kinner. This seems to be working. Does this mean that if we backup the DB with a script, then we cannot restore it using the UI? Is there any way to achieve this?

OdooBot

Hi Shawn,

Odoo use zip to compress db while the command I sent you use gzip. Both uses different compression algorithm to compress and decompress file.

In order to use UI restore tool the db must be zip compressed or plain sql dump.

Hope this helps you.

Regards,
Kinner

Thanks a lot Kinner. This seems to be working. Does this mean that if we backup the DB with a script, then we cannot restore it using the UI? Is there any way to achieve this?

--
Shawn
Sent by Odoo S.A. using Odoo about Forum Post False

Rubén Cabrera

When having problems to restore DBs from different servers (some of them with different versions of postgres or postgres-client), this is the only way to solve them for me.

Thanks, I've had this answer bookmarked for a while and keep coming back.

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire

Publications associées	Réponses	Vues
Command pg_dump not found Résolu v8 backup	6 mai 24	64352
can i add the source code of a module through the web interface? postgresql backup	0 mars 23	2295
Incremental backup in 2024 ? (self hosted) database postgresql backup	0 juin 24	1707
Creating many records in a loop sometimes does not work v8 create postgresql	2 mars 20	4925
Trying to get manufacturer,(partner name) getting TypeError: string indices must be integers v8 python postgresql	0 mars 15	5353

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !