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
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.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Oct 24
|
3995 | |||
|
1
Jul 24
|
10929 | |||
|
4
Sep 20
|
6953 | |||
|
A column for Sizes of shoes
Solved
|
2
Mar 20
|
5551 | ||
|
0
Mar 18
|
4191 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
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.