Data Protection Advisor - How to check the size of a datastore/database (DB) export?
Summary: A database export is deemed a valid backup of the DPA datastore. They should be run regularly and also required prior to any upgrade or changes being made to the datastore. Space is needed, but how to check the size of a datastore export? ...
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Instructions
NOTE: There is no command to determine the size of a database export without having an existing export to check.
However, the following command can be run:
Linux: <install dir>/opt/emc/dpa/services/bin> ./dpa.sh ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"
Windows: <install dir>\emc\dpa\services\bin> dpa ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"
The output reflects the size of the DPA datastore (db). A db export is typically 1/10th of the size of this db but this may vary.
This is a general rule. There are exceptions to this if there are large indexes on the db.
Always place the db export outside of the DPA install directory for safety and space reasons.
Example:
dpaapp@lab]# ./dpa.sh ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"
EMC Data Protection Advisor
pg_size_pretty
----------------
87 GB
(1 row)
87GB is the size of the db thus we would expect the size of the db export to be over 8GB.
However, the following command can be run:
Linux: <install dir>/opt/emc/dpa/services/bin> ./dpa.sh ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"
Windows: <install dir>\emc\dpa\services\bin> dpa ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"
The output reflects the size of the DPA datastore (db). A db export is typically 1/10th of the size of this db but this may vary.
This is a general rule. There are exceptions to this if there are large indexes on the db.
Always place the db export outside of the DPA install directory for safety and space reasons.
Example:
dpaapp@lab]# ./dpa.sh ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"
EMC Data Protection Advisor
pg_size_pretty
----------------
87 GB
(1 row)
87GB is the size of the db thus we would expect the size of the db export to be over 8GB.
Affected Products
Data Protection AdvisorArticle Properties
Article Number: 000203586
Article Type: How To
Last Modified: 10 Mar 2023
Version: 7
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.