Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
v8postgresqlbackup
1 ตอบกลับ
26549 มุมมอง
อวตาร
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
คำตอบที่ดีที่สุด

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
ผู้เขียน

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

<blockquote cite="mid:1444999839.406162977218628.220056323948286-openerp-92332-forum.post@accounts-a.odoo.com" type="cite">

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.

Related Posts ตอบกลับ มุมมอง กิจกรรม
Command pg_dump not found แก้ไขแล้ว
v8 backup
อวตาร
อวตาร
อวตาร
อวตาร
อวตาร
6
พ.ค. 24
65715
can i add the source code of a module through the web interface?
postgresql backup
อวตาร
0
มี.ค. 23
3011
Incremental backup in 2024 ? (self hosted)
database postgresql backup
อวตาร
0
มิ.ย. 24
2520
Creating many records in a loop sometimes does not work
v8 create postgresql
อวตาร
อวตาร
2
มี.ค. 20
5673
Trying to get manufacturer,(partner name) getting TypeError: string indices must be integers
v8 python postgresql
อวตาร
0
มี.ค. 15
6200