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.
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
Command pg_dump not found
Risolto
|
|
6
mag 24
|
65459 | |
|
0
mar 23
|
2917 | ||
|
0
giu 24
|
2415 | ||
|
2
mar 20
|
5607 | ||
|
0
mar 15
|
6030 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
