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,
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