Backing up the Usage Meter database

Products

• VMware Aria Suite

Issue/Introduction

This article provides steps to back up the Usage Meter database for troubleshooting.

Environment

VMware vCloud Usage Meter 3.3.x
VMware vCloud Usage Meter 3.4.x

Resolution

To back up the Usage Meter database:

1. Log in using root to the Usage Meter appliance via SSH or console connection.
2. Run these commands:
   
   
   • cd /
   • sudo -u postgres /opt/vmware/vpostgres/current/bin/pg_dump --format=p --file=/tmp/umbackup-plain usgmtr
     
     This creates a file in /tmp/umbackup-plain which is a backup of the database.

Note: This works for Usage Meter 3.3, 3.4, and 3.5. In previous versions, replace the usgmtr database name with usage_meter_db.

Additional Information