PostGre SQL - How big can it get?
Hi There,
Looks like the below PostgreSQL database folder has been growing rapidly and it is at 43GB now. Is there a way to reduce the size?
C:\Program Files\PostgreSQL\Data\base
Thanks, Rijath Mohammed
Hi There,
Looks like the below PostgreSQL database folder has been growing rapidly and it is at 43GB now. Is there a way to reduce the size?
C:\Program Files\PostgreSQL\Data\base
Thanks, Rijath Mohammed
Hi,
The PostgreSQL server database contains the agent/backup related information as well as meta-data information of the backed-up data, which is needed for recovery process. The size of the PostgreSQL Data folder can vary depends upon the size of the total backup data stored in the backup server. The approximate database size may be around 1% of total backed-up data size. So when the backed up data size grows, the database size will also grow up accordingly and it can't be shrinked.
If the database is getting bigger and if you don't have enough space on the drive, you can move the postgres db location to a different drive which has enough space, by following the below KB article,
Copyright © Vembu Technologies 2022. All Rights Reserved.