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.
| 관련 게시물 | 답글 | 화면 | 활동 | |
|---|---|---|---|---|
|
6
5월 24
|
64348 | ||
|
0
3월 23
|
2291 | ||
|
0
6월 24
|
1706 | ||
|
2
3월 20
|
4923 | ||
|
0
3월 15
|
5349 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
