How to check the size of the internal database in RSA Authentication Manager 8.x
Originally Published: 2016-08-11
Article Number
Applies To
RSA Product/Service Type: RSA Authentication Manager
RSA Version/Condition: 8.x
Issue
Resolution
- Ensure access to the primary via SSH is enabled on the primary via the Operations Console.
- Open an SSH session on the Authentication Manager primary and run the commands below:
login as: rsaadmin Password: <enter the operating system password>
- Capture the rsa.db.dba.password information using the ./rsautil manage-secrets -a get com.rsa.db.dba.password command. Enter the Operations Console admin name and password when prompted.
- The database password is echoed back.
- Connect to database with the ./psql command.
- Paste the database password when prompted
rsaadmin@am81p:~> cd /opt/rsa/am/utils
rsaadmin@am81p:/opt/rsa/am/utils> ./rsautil manage-secrets -a get com.rsa.db.dba.password
Please enter OC Administrator username: <enter the Operations Console admin's name>
Please enter OC Administrator password: <enter the Operations Console admin's password>
com.rsa.db.dba.password: <com.rsa.db.dba.password string>
rsaadmin@am81p:/opt/rsa/am/utils> cd ../pgsql/bin
rsaadmin@am81p:/opt/rsa/am/pgsql/bin> ./psql -h localhost -p 7050 -d db -U rsa_dba
Password for user rsa_dba: <enter the com.rsa.db.dba.password captured above>
- In the command line, type the query shown here as one line:
SELECT relname AS "Table", pg_size_pretty(pg_total_relation_size(relid)) AS "Size", pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) AS "External Size" FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;
Output will be as follows:
db=# SELECT relname AS "Table", pg_size_pretty(pg_total_relation_size(relid)) AS "Size",
pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size"
FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;
Table | Size | External Size
------------------------------------------+------------+---------------
ims_log_system | 13 MB | 7248 kB
ims_batch_job | 3560 kB | 3424 kB
ims_instance_node | 2552 kB | 248 kB
am_p2r_primarystatus | 2000 kB | 72 kB
ims_config_value | 1104 kB | 584 kB
am_token | 904 kB | 440 kB
am_r2p_primarystatus | 872 kB | 104 kB
am_token_attr_values | 648 kB | 464 kB
am_p2r_combinedstatus | 648 kB | 96 kB
am_r2p_combinedstatus | 640 kB | 88 kB
ims_config_metadata | 568 kB | 392 kB
re_configuration | 496 kB | 384 kB
entity_aggregations | 472 kB | 360 kB
rba_bs_buckets_static | 432 kB | 136 kB
ims_admin_permission | 392 kB | 272 kB
am_token_attribute | 360 kB | 232 kB
ims_log_keys | 296 kB | 80 kBRelated Articles
DSA-2020-140: RSA Identity Governance and Lifecycle Security Update for SUSE Linux Enterprise Server Vulnerabilities 3Number of Views SecurID Internal Database Password Algorithm 70Number of Views Upgrading the Internal SecurID Authentication Manager 8.6 Certificates to SHA-256 483Number of Views Set the RSA Authentication Manager internal database password to optional 228Number of Views Internal database user(s) cannot be enrolled for the Cloud Authentication Service on RSA Authentication Manager 8.4 for RS… 56Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) How to install the jTDS JDBC driver on WildFly for use with Data Collections in RSA Identity Governance & Lifecycle RSA Authentication Manager 8.8 Setup and Configuration Guide Artifacts to gather in RSA Identity Governance & Lifecycle
Don't see what you're looking for?