[Avamar]DellEMC Avamar PostgreSQL Query 방법

개요

- DellEMC Avamar PostgreSQL Query 방법

 

1. Avamar admin User 접속

 

2. admin@ave182:~/>: psql -p 5555 -U admin mcdb

 

3. psql Log /tmp/pg.log 에 Spool

mcdb=# \o /tmp/pg.log

4. Avamar PostgreSQL Query List

# Client 등록 정보

mcdb=# SELECT * FROM "public"."v_clients";

 

# Backup Client 정보

mcdb=# SELECT * FROM "public"."v_groups";

 

# Backup Activity 정보

mcdb=# SELECT * FROM "public"."v_activities";

 

# Avamar 사용량

mcdb=# SELECT * FROM "public"."v_node_space";