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:
- CRM
- e-Commerce
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
5
Replies
4885
Tampilan
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.
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
Download database with only master data
Diselesaikan
|
|
2
Okt 24
|
1878 | |
|
1
Jul 24
|
6812 | ||
|
4
Sep 20
|
5367 | ||
|
A column for Sizes of shoes
Diselesaikan
|
|
2
Mar 20
|
3871 | |
|
0
Mar 18
|
2774 |
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.