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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
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.
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.
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.
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 | Hoạt động | |
---|---|---|---|---|
|
2
thg 10 24
|
1872 | ||
|
1
thg 7 24
|
6799 | ||
|
4
thg 9 20
|
5364 | ||
A column for Sizes of shoes
Đã xử lý
|
|
2
thg 3 20
|
3860 | |
|
0
thg 3 18
|
2763 |
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.