000033755 - How to get the version of PostgreSQL used with RSA Authentication Manager 8.x

Document created by RSA Customer Support Employee on Aug 25, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033755
Applies ToRSA Product Set: SecurID 
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
IssueThis article provides the steps to determine which version of PostgreSQL is being used with Authentication Manager 8.x.
  1. From the primary's Operations Console, navigate to Administration > Operating System Access.
  2. If it is not already enabled, check the box for Enable SSH.  When done, click Save.
  3. Open an SSH session on the Authentication Manager primary and login as the rsaadmin user:
    login as: rsaadmin
    Password: <enter OS password>

  4. Next, capture the database password and connect to database:
    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>

  5. Type the command below to get the version of PostgreSQL:
    db=# SELECT 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)