Obtain the version of PostgreSQL used with RSA Authentication Manager 8.x

[#1]

Article Number

000033755

Applies To

RSA Product Set: SecurID 
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x

Issue

This article provides the steps to determine which version of PostgreSQL is being used with RSA Authentication Manager 8.x.

Resolution

1. Enable Secure Shell on the Appliance.
2. Log on to the Appliance Operating System with SSH.
3. Next, capture the database password for user rsa_dba to connect to database.  Note that the password for each RSA AUthentication Manager deployment is different.

login as: rsaadmin
Using keyboard-interactive authentication.
Password: <enter operating system password>
Last login: Tue Jan  7 10:08:28 2020 from jumphost.vcloud.local
RSA Authentication Manager Installation Directory: /opt/rsa/am
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 Operations Console administrator user name> 
Please enter OC Administrator password: <enter Operations Console administrator's password> 
com.rsa.db.dba.password: rSKD5bGguLGNL9uGvFWnJoxIcHJah2 
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>

4. Type the command below to get the version of PostgreSQL:

db=# SELECT version();
                                                   version
---------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit
(1 row)