Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
4 Odpowiedzi
21479 Widoki

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....

Awatar
Odrzuć

Paste some error traces from posgresql log file

Autor

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.

Najlepsza odpowiedź

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. :)

Awatar
Odrzuć
Najlepsza odpowiedź

I had the same error.

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

Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć
Autor

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.

Autor Najlepsza odpowiedź

hi guys,

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

Awatar
Odrzuć

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

Powiązane posty Odpowiedzi Widoki Czynność
2
paź 24
1815
0
wrz 23
1866
0
wrz 23
1575
2
cze 25
10988
6
paź 23
21830