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 Backup & Replication 13.0.2.29

https://www.veeam.com/kb4738