Purge embedded postgres database

login to database using psql utility as postgres user, issue the command

VACUUM FULL;

This will release space used by update and delete commands.  If you do not have much update and deletes in your system then you have run out of space pure and simple.  You need to review what table data can be archived.  You can take this opportunity to partition your data to automate this process.

psql utility is this a free download and what would the postgres user be? also why would a 2 hosts VCenter with 10 VM's take so much space for database?

Thanks

Likely best to open a Gig to investigate reason for disk usage, as this could take a good bit of time to figure out.

Might require tracking logs across a very long time.

Easy solution I used when running PostgreSQL (years ago).

Create a CRON job to do a nightly VACUUM FULL; + if problem persists, then drill down into your logs to determine the reason.

psql should be available on your build if postgresql is installed unless it has been specifically deleted.  Failing that you can start the postgres service in single user interactive mode if necessary.  Why so much data ? Maybe you should evaluate what you are logging in vcenter.

Andrew, will this continue to grow if i increase the space? where does one stop?

Thanks

size the disk correctly, VMware got it wrong in 5.5 it also depends on how many hosts and VMs you have, so how many is this ?

2 hosts, 10 vms and Veeam backup.

That's very small but early VCSA did have issues

I think there is an update 3 available, should I update that?

Yes, you should always be on the latest!

ok . I will update and report back.

Hi Any ideas how I can increase the disk space within VCenter Appliance please? see attached screen prints, am a bit confused as its showing some available disk space for the database partition yet it saying 99% used in vcenter?

can someone please assist in increasing disk space via GParted or any other easier method/s?

Thanks
1.PNG
2.PNG