Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
1837 Tampilan

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
Buang
Penulis Jawaban Terbai

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
Buang
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
1
Agu 24
2087
2
Apr 24
1434
1
Apr 24
1895
2
Apr 25
1030
0
Des 24
804