Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
5 Antworten
4882 Ansichten

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

Avatar
Verwerfen

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.

Beste Antwort

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.

Avatar
Verwerfen
Autor

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.

Autor Beste Antwort

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.

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
2
Okt. 24
1878
1
Juli 24
6804
4
Sept. 20
5366
2
März 20
3863
0
März 18
2771