Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
5 Trả lời
4875 Lượt xem

Hi,

I have been playing Odoo 9 for a while now. I recently notice that my database backups are shrinking in size (substantially) after each backup. Does Odoo or PostgreSQL somehow optimize the database after a period of time?

Thanks

Antonio

Ảnh đại diện
Huỷ bỏ

I've noticed that some of the product pictures are missing after each database backup.
Not really sure what to do to prevent it happening.

Câu trả lời hay nhất

I doubt that, unless you actually removed records from the database, or removed files from the filestore in case of zip backups. If neither is the case, I would check a restore of one of the small dumps and check whether there is data missing. I had incomplete dumps without error message recently but that may have been due to a misconfiguration on my side.

Ảnh đại diện
Huỷ bỏ
Tác giả

Thanks, I will check. At a glance it seems the sql dump is smaller in size,but I couldn't tell what is missing now.

Convert a big and a small dump to sql txt file "pg_restore db1.dump > db1.sql", then count the lines and compare "cat db1.sql | wc -l". It is only a crude measure but it should give a hint.

Tác giả Câu trả lời hay nhất

Thanks Mark. I found that the temp data or so called transient data were deleted after a period of time by Odoo and that made a huge size difference on the dump.

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 10 24
1872
1
thg 7 24
6799
4
thg 9 20
5364
2
thg 3 20
3860
0
thg 3 18
2763