Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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.
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
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?
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?
--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.
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren| Verknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
|---|---|---|---|---|
|
Command pg_dump not found
Gelöst
|
|
6
Mai 24
|
65905 | |
|
0
März 23
|
3086 | ||
|
0
Juni 24
|
2651 | ||
|
2
März 20
|
5788 | ||
|
0
März 15
|
6316 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
