DX NetOps

Expand all | Collapse all

history of the database

Jump to Best Answer
  • 1.  history of the database

    Posted 04-25-2019 02:24 PM

    How can I see the saved history and its size of the database?

  • 2.  Re: history of the database
    Best Answer

    Posted 04-30-2019 07:43 AM

    HI Joan:


    I assume you mean the vertica database.  Here are a few different methods to list backups:


    Run the following command:


     /opt/vertica/bin/vbr.py --task listbackup --config-file /export/dradmin/fullbackup.ini


    Run the following query in vsql:


    select * from v_monitor.database_backups;



    For database size you might run the following query:


    drdata=> select storage_path, storage_usage, disk_space_used_mb, disk_space_used_mb / 1024 "disk_space_used_mb (GB)" from disk_storage where node_name = 'v_drdata_node0001';
    storage_path | storage_usage | disk_space_used_mb | disk_space_used_mb (GB)
    /loddisk2/catalog/drdata/v_drdata_node0001_catalog/Catalog | CATALOG | 6832 | 6.671875000000000000
    /loddisk2/data/drdata/v_drdata_node0001_data | DATA,TEMP | 6832 | 6.671875000000000000
    (2 rows)