Wednesday, March 27, 2019

Deletion of tasks, events, historical performance data befor upgrading vCSA

Remove tasks, events, and historical performance data befor upgrading vCSA


In some situation it is only possible to select XL configuration when upgrading vCSA from 6.0 to 6.5. Remove tasks, events and historical performance data to freeup space in Postgres db. 

https://kb.vmware.com/s/article/2110031


/opt/vmware/vpostgres/current/bin/psql -U postgres -v TaskMaxAgeInDays=10 -v EventMaxAgeInDays=10 -v StatMaxAgeInDays=10 -d VCDB -t -q -f /tmp/2110031_Postgres_task_event_stat.sql


In example , 10 days.




RECENT POSTS

February 1, 2022 - end-of-support of the following products

  This message is to inform you that effective   February 1, 2022 , the following products will reach end-of-support: Veeam ®   Backup &...