Skip to Content
This question has been flagged
helpodooodoo16
2 Replies
1627 Views
Avatar
khan

Hi everyone,


I'm facing a discrepancy in my PostgreSQL database management:

i have check my datbase size from backend with this command 


SELECT

    datname AS database_name,

    pg_size_pretty(pg_database_size(datname)) AS database_size

FROM

    pg_database

ORDER BY

    pg_database_size(datname) DESC;



Database Size Reports from this command around 1135 MB.

But when I downloaded the backup from myinstance/web/database/manager, it around 15Gb increased suddenly. this is a high alert for me, please help me

Any insights on why the backup size differs significantly from the database size? Your expertise would be greatly appreciated!


Thanks,

Avatar
Discard
Avatar
khan
Author Best Answer

i have check my filestore size which is now 20 gb

root@vmi991291:~/services/test_instance# du -sh data/filestore/Restored/

20G  data/filestore/Restored/

root@vmi991291:~/services/test_instance#

kindly tell me what should i do  because now i can't even take the backups


Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

Attachments like PDFs, images, and other documents are stored in the filestore.

The database only stores metadata about these attachments (such as file name, file type, and path to the file in the filestore).

The backup size will include the database size and the filestore size. If the filestore contains a large number of attachments, it can significantly increase the overall backup size.


Avatar
Discard
Related Posts Replies Views Activity
Como puedo poner el campo de una relación Many2one es un selection?
help odoo
Avatar
Avatar
1
Aug 24
1854
calcule amount_taxed in stock_picking Solved
help odoo
Avatar
Avatar
2
Apr 24
1319
ValueError: Compute method failed to assign product.product(627,).alert_tag
help odoo
Avatar
Avatar
1
Apr 24
1722
Events on field change in Odoo 16
odoo odoo16features odoo16
Avatar
Avatar
2
Apr 25
913
Inter company transfer error
intercompany odoo odoo16
Avatar
0
Dec 24
722