SoftActivity

How to reset PostgreSQL database password for SoftActivity software

By default, SoftActivity uses PostgreSQL database user name: softactivity
with the same password as the administrator have set for TS Monitor or Activity Monitor product during installation.
By default, connections to the database only can be made from a local computer where PostgreSQL is installed.

To reset PostgreSQL database password in SoftActivity product, follow these steps:

  1. Open Database tab in TS Monitor or Activity Monitor settings, click Check Connection to verify connection settings:
  2. Try the password used to open Activity Monitor or TS Monitor. If it’s still not accepted, you can reset the password for the database.
  3. Click About tab, click PostgreSQL config files link to open the database’s pgdata folder.
  4. Back up pg_hba.conf there found there.
  5. Open pg_hba.conf file in Notepad and add these 2 lines:
    host all all 127.0.0.1/32 trust
    host all all ::1/32 trust

    Warning: this line allows any user to connect to the database from the local computer without password authentication. This line must be removed later

  6. Restart PostgreSQL server by restarting SapgSrv service in Windows Services or from command line:
    sc stop SapgSrv
    sc start SapgSrv

    Make sure that SapgSrv service has started and is in Running state. If pg_hba.conf file has been incorrectly formatted after editing, the service might not start.

  7. Open Command Prompt in this folder:
    "C:\Program Files (x86)\SoftActivity\Activity Monitor\postgres\bin" or
    "C:\Program Files (x86)\SoftActivity TS Monitor\postgres\bin"
  8. Run from Command line:
    psql -h localhost -U softactivity -d postgres
    ,where softactivity: user name used for connection
    postgres – database name
    It should not ask for password and will connect you to the database from command line.
  9. Enter the following command that changes password for user softactivity (replace my_secure_password with an actual unique password):
    ALTER USER softactivity with password 'my_secure_password';
    and press Enter to execute.
    Type \q and press Enter to exit psql
  10. Important: Restore pg_hba.conf to its original state, restart SapgSrv
  11. Enter your new password on Database tab in Settings and click Check Connection to verify that it’s accepted now.