I will soon upgrade a large CPPM deployment for a customer. I want to prepare them for how long the upgrade will take. Reviewing 6.8 release notes gives timeframes which are all very reasonable. I need to confirm the customers deployment falls somewhere near the same sample sizes and are not way outside the bounds.
How do I view the DB sizes so that I can make the correct calculations?
You need to take TAC help to get db size detials of LogDB, InsightDB, tipsDB.
I suspected that might be the answer. It would be great to give us the ability to view this ourselves. I will backup and export as jrwhitehead has suggested and I will compare this to TAC findings. I will post back here what is found. It will be a few weeks though.
You can collect the complete server logs from Administration --> Server Manager --> Server Configuration --> Collect logs.
Untar the logs and navigate to the file named "postgres-info.txt" in the PolicyManager folder. It would show the size of all databases on that node.
Below is an example:
Size of all databases:datname | size-------------+---------postgres | 7343 kBAppPlatform | 44 MBtemplate1 | 7343 kBtemplate0 | 7343 kBinsightdb | 14 MBtipsdb | 10 GBtipsLogDb | 474 MB(7 rows)
At Aruba, we believe that the most dynamic customer experiences happen at the Edge. Our mission is to deliver innovative solutions that harness data at the Edge to drive powerful business outcomes.
© Copyright 2020 Hewlett Packard Enterprise Development LPAll Rights Reserved.