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:
- सीआरएम
- e-Commerce
- लेखांकन
- इन्वेंटरी
- PoS
- Project
- MRP
This question has been flagged
5
Replies
4872
Views
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.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
अक्तू॰ 24
|
1871 | ||
|
1
जुल॰ 24
|
6797 | ||
|
4
सित॰ 20
|
5362 | ||
|
A column for Sizes of shoes
Solved
|
|
2
मार्च 20
|
3857 | |
|
0
मार्च 18
|
2760 |
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.