Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
4 ตอบกลับ
21482 มุมมอง

Can anyone help me out on this, i give the master password but still does not work. the error is as given below.


Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpRgZcCN/dump.sql', u'odoo-DB') error 1


Thanks in advance....

อวตาร
ละทิ้ง

Paste some error traces from posgresql log file

ผู้เขียน

ERROR: could not obtain lock on row in relation "ir_cron" 2016-05-03 05:26:35 UTC:10.0.0.172(45855):staging@staging_odoo:[9476]:STATEMENT: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall

You are my hero!!!

Just for others: This resolves the backup issue for all using Postgis database extensions.

คำตอบที่ดีที่สุด

Hello,

Maybe it would help to some others. I solved this by doing following commands on Postgresql DB. According to  installation Freight Management System module, on my Postgresql created "topology" schema.

GRANT ALL PRIVILEGES ON SCHEMA topology TO odoo;

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA topology TO odoo;

GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA topology TO odoo;

After that Odoo DB backup runs without any problem. :)

อวตาร
ละทิ้ง
คำตอบที่ดีที่สุด

I had the same error.

Just make sure PG client and server is same version and it should be fine.

อวตาร
ละทิ้ง
คำตอบที่ดีที่สุด

please try this answer given in question:

https://www.odoo.com/forum/help-1/question/how-can-i-take-back-of-database-by-terminal-101505

อวตาร
ละทิ้ง
ผู้เขียน

Hi Krupesh, First of all thank for replying, the link which you suggested gives solution with respect to the script and backup (storing in dump), the error which im getting is in the web browzer. my scenario here is i have a EC2 instance and also RDS connected to it. I am not able to take a back up from the web Browzer of odoo database manager. Please guide me, i need to download the file that is the backup to my local system.

ผู้เขียน คำตอบที่ดีที่สุด

hi guys,

I solved the issue, it was a mismatch between pg_dump....

อวตาร
ละทิ้ง

Can u give a detailed solution, so as to solve this issue.

Please more details... I installed a back-end theme, now I can't even access any part of my current Odoo not even the login page... I can only access the manage database page

Related Posts ตอบกลับ มุมมอง กิจกรรม
Download database with only master data แก้ไขแล้ว
2
ต.ค. 24
1817
0
ก.ย. 23
1867
0
ก.ย. 23
1576
2
มิ.ย. 25
10988
6
ต.ค. 23
21830