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
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
5
Risposte
4888
Visualizzazioni
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.
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
2
ott 24
|
1879 | ||
|
1
lug 24
|
6812 | ||
|
4
set 20
|
5367 | ||
|
A column for Sizes of shoes
Risolto
|
|
2
mar 20
|
3875 | |
|
0
mar 18
|
2777 |
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.