Backing up the Usage Meter database
search cancel

Backing up the Usage Meter database

book

Article ID: 339851

calendar_today

Updated On:

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