Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
1985 Widoki

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,

Awatar
Odrzuć
Autor Najlepsza odpowiedź

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


Awatar
Odrzuć
Najlepsza odpowiedź

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.


Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
sie 24
2205
2
kwi 24
1519
1
kwi 24
2041
2
kwi 25
1138
0
gru 24
886