last person joined: 19 hours ago 

Enterprise security using ClearPass Policy Management, ClearPass Security Exchange, IntroSpect, VIA, 360 Security Exchange, Extensions and Policy Enforcement Firewall (PEF).
Expand all | Collapse all

Clearpass - View DB Sizes

  • 1.  Clearpass - View DB Sizes

    Posted Jan 28, 2020 03:33 PM

    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?







  • 2.  RE: Clearpass - View DB Sizes

    Posted Jan 29, 2020 07:06 AM
    If you backup your CPPM instance you will get the "Total Backup Size".

    If you extract your backup you should be able to see how large the databases are.

    Config & Log DB backups are in the PolicyManager directory.
    Insight DB backup is in the Insight directory.

    I'm not 100% sure that these DB backups reflect the exact size of the DB on ClearPass though but it's something... Maybe someone from Aruba/HPE can chip in?

  • 3.  RE: Clearpass - View DB Sizes

    Posted Jan 29, 2020 10:12 AM

    You need to take TAC help to get db size detials of LogDB, InsightDB, tipsDB.

  • 4.  RE: Clearpass - View DB Sizes

    Posted Jan 29, 2020 10:24 AM

    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. 


    Thanks guys! 

  • 5.  RE: Clearpass - View DB Sizes

    Posted Feb 20, 2020 12:52 AM

    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 kB
    AppPlatform | 44 MB
    template1 | 7343 kB
    template0 | 7343 kB
    insightdb | 14 MB
    tipsdb | 10 GB
    tipsLogDb | 474 MB
    (7 rows)