VMWARE - HOW TO FIND THE SIZE OF VRA POSTGRES DATABASE

VMWARE - HOW TO FIND THE SIZE OF VRA POSTGRES DATABASE

 

Please follow the below steps to find out the size of the VRA Postgres Database

 

1) Login to the VRA appliance via putty and connect it via root account.

 

2) Now switch to the user postgres by typing in the command:-

 

Command:-  su postgres   

3) Now type in the command to connect to database.

Command:- psql vcac

4) Now to check the size of the VRA Postgres database, type in the command and press enter:-

  

Command:-

SELECT
   pg_database.datname,
   pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database;

5) This would show you the current size of the VRA Postgres Database.