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.
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-se| Related Posts | Respostes | Vistes | Activitat | |
|---|---|---|---|---|
|
Command pg_dump not found
Solved
|
|
6
de maig 24
|
65688 | |
|
0
de març 23
|
3007 | ||
|
0
de juny 24
|
2513 | ||
|
2
de març 20
|
5671 | ||
|
0
de març 15
|
6180 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
