Backup database not working

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kế toán
Tồn kho
PoS
Project
MRP

All apps

Tất cả bài viết Người Huy hiệu

Thẻ (Xem tất cả)

odoo accounting v14 pos v15

Về diễn đàn này

Hỗ trợ

Backup database not working

backup restoredb

3 Trả lời

9192 Lượt xem

Jérôme Mouchès

Hello,

I have a problem when i try to backup my database, i could not open the zip file or restore it. I have the error message below

Database restore error: Postgres subprocess ('/usr/bin/pg_restore', '--dbname=my_database', '--no-owner', '/tmp/tmp8f53r4mf') error 1

I was using paramiko maybe it could be the reason of this problem, but then i uninstall it.

When i create a new database and try to make a backup it works without any problem. The issue is only with my first database. I have my customer's data there so i cannot just drop it and create new one

Thanks in advance

Ivan

Hi, try to backup your database from web with the url link: http://youdomain.com/web/database/manager

ps. please upvote (I need 3 Karma)

Adesh Paul

go to the terminal

>> sudo -u postgres psql

postgres=# \c <your_database_name>

your_database_name=# DELETE FROM ir_ui_view WHERE key ILIKE '%web_editor.scss_%' AND mode='extension';

Anusha

Hi,

Just refer to this link I think it may help you https://www.odoo.com/fr_FR/forum/aide-1/question/error-restoring-database-92322.

Jérôme Mouchès

Tác giả

Thank you for your answer Anu. My problem is in backup database it's not working i tried to unzip it but it show an error and it never work on restore, i used odoo interface then restore with command and both are not working

Anusha

Hi,

Did you try to restore from the UI?

You can also restore it from CLI(terminal).

first create a db with the same name of the db you want to restore.

Then back up is in zip format then

gunzip -c backup_name.zip | psql db_name

if it is in gz format

zcat backup_name.sql.gz | psql db_name

Make sure you give superuser permissions to DB owner

Jérôme Mouchès

Tác giả

when i do backup with terminal i got this error on the interface

The style compilation failed, see the error below. Your recent actions may be the cause, please try reverting the changes you made.

Error: Undefined variable: "$mk-brand-gradient-start".

on line 7985 of stdin

>> radient: linear-gradient(to right bottom, $mk-brand-gradient-start, $mk-bran

------------------------------------------^

This error occured while compiling the bundle 'web.assets_backend' containing:

- /web/static/lib/bootstrap/scss/_functions.scss

- /web/static/lib/bootstrap/scss/_mixins.scss

- /web/static/src/scss/utils.scss

- /web/static/src/scss/bs_mixins_overrides.scss

- /muk_web_theme/static/src/scss/mixins.scss

- /web/static/src/scss/primary_variables.scss

- /muk_web_theme/static/src/scss/colors.custom.muk_web_theme._assets_primary_variables.scss

- /web_editor/static/src/scss/web_editor.variables.scss

- /mail/static/src/scss/variables.scss

- /portal/static/src/scss/primary_variables.scss

- /web/static/src/scss/secondary_variables.scss

- /web/static/src/scss/bootstrap_overridden.scss

- /muk_web_theme/static/src/scss/variables.scss

- /web_editor/static/src/scss/bootstrap_overridden.scss

- /web/static/src/scss/import_bootstrap_part1.scss

- /web/static/src/scss/bs_mixins_overrides.scss

- /web/static/src/scss/import_bootstrap_part2.scss

- /web/static/src/scss/bootstrap_review.scss

- /web/static/src/scss/webclient_extra.scss

- /web/static/src/scss/webclient_layout.scss

- /web/static/src/scss/webclient.scss

- /web/static/src/scss/domain_selector.scss

- /web/static/src/scss/model_field_selector.scss

- /web/static/src/scss/progress_bar.scss

- /web/static/src/scss/dropdown.scss

- /web/static/src/scss/dropdown_extra.scss

- /web/static/src/scss/tooltip.scss

- /web/static/src/scss/debug_manager.scss

- /web/static/src/scss/control_panel.scss

- /web/static/src/scss/fields.scss

- /web/static/src/scss/fields_extra.scss

- /web/static/src/scss/views.scss

- /web/static/src/scss/pivot_view.scss

- /web/static/src/scss/graph_view.scss

- /web/static/src/scss/form_view.scss

- /web/static/src/scss/form_view_extra.scss

- /web/static/src/scss/list_view.scss

- /web/static/src/scss/list_view_extra.scss

- /web/static/src/scss/kanban_dashboard.scss

- /web/static/src/scss/kanban_examples_dialog.scss

- /web/static/src/scss/kanban_column_progressbar.scss

- /web/static/src/scss/kanban_view.scss

- /web/static/src/scss/kanban_view_mobile.scss

- /web/static/src/scss/web_calendar.scss

- /web/static/src/scss/search_view.scss

- /web/static/src/scss/search_view_mobile.scss

- /web/static/src/scss/dropdown_menu.scss

- /web/static/src/scss/search_view_extra.scss

- /web/static/src/scss/data_export.scss

- /base/static/src/scss/onboarding.scss

- /web/static/src/scss/base_settings.scss

- /web/static/src/scss/report_backend.scss

- /base_import/static/src/scss/base_import.scss

- /web_diagram/static/src/scss/diagram_view.scss

- /web_editor/static/src/scss/web_editor.common.scss

- /web_editor/static/src/scss/web_editor.backend.scss

- /muk_web_utils/static/src/scss/variables.scss

- /muk_web_utils/static/src/scss/mixins.scss

- /muk_web_utils/static/src/scss/switch.scss

- /muk_web_utils/static/src/scss/dropzone.scss

- /muk_web_utils/static/src/scss/module.scss

- /muk_web_utils/static/src/scss/color.scss

- /muk_web_utils/static/src/scss/image.scss

- /muk_web_utils/static/src/scss/copy.scss

- /muk_web_utils/static/src/scss/share.scss

- /muk_web_utils/static/src/scss/notification.scss

- /muk_web_theme/static/src/scss/layout.scss

- /muk_web_theme/static/src/scss/navbar.scss

- /muk_web_theme/static/src/scss/apps.scss

- /muk_web_theme/static/src/scss/appsbar.scss

- /muk_web_theme/static/src/scss/control_panel.scss

- /muk_web_theme/static/src/scss/list_view.scss

- /muk_web_theme/static/src/scss/form_view.scss

- /muk_web_theme/static/src/scss/fields.scss

- /mail/static/src/scss/announcement.scss

- /mail/static/src/scss/discuss.scss

- /mail/static/src/scss/abstract_thread_window.scss

- /mail/static/src/scss/thread_window.scss

- /mail/static/src/scss/composer.scss

- /mail/static/src/scss/chatter.scss

- /mail/static/src/scss/followers.scss

- /mail/static/src/scss/thread.scss

- /mail/static/src/scss/systray.scss

- /mail/static/src/scss/mail_activity.scss

- /mail/static/src/scss/activity_view.scss

- /mail/static/src/scss/kanban_view.scss

- /mail/static/src/scss/attachment_box.scss

- /calendar/static/src/scss/calendar.scss

- /partner_autocomplete/static/src/scss/partner_autocomplete.scss

- /sales_team/static/src/scss/sales_team_dashboard.scss

- /hr/static/src/scss/hr.scss

- /hr_recruitment/static/src/scss/hr_job.scss

- /web_settings_dashboard/static/src/scss/dashboard.scss

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!

Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!

Đăng ký

Bài viết liên quan	Trả lời	Lượt xem
Restore database problem Đã xử lý backup restoredb	2 thg 8 24	10299
error backup restoredb	1 thg 11 22	2863
How to restore database from backup in V16 online ? backup restoredb odoo16features	6 thg 6 25	14825
Restore completes but database not visible Đã xử lý backup restore restoredb	3 thg 1 22	5005
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 Đã xử lý backup	9 thg 7 25	64939

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!