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.




No comments:

Post a Comment

RECENT POSTS

Veeam One : 12.2.0.4093

Version history: • 12.2.0.4093 (August 28th, 2024) >  What's New in 12.2