TrueSight Presentation Server does not start due to PostgreSQL DB unavailability

Issue: The TrueSight Presentation Server does not start due to database server not available.

Solution: Do the following steps to resolve the issue:

1. Ensure that you have created a back up of PostgreSQL DB files as mentioned in the Preparing-to-upgrade-the-Presentation-Server topic.
2. Check the logs at the (Windows) TrueSightPServer\truesightpserver\logs\pg_logs or (Linux) TrueSightPServer/truesightpserver/logs/pg_logs location.

3. Open the recently created log file postgresql-timestamp.log and search for the following error message:

   PANIC: could not find a valid checkpoint record
4. If the log file contains the preceding error message, do the following steps:

1. 
   

   1. From the Presentation Server host command prompt, go to:
      (On Windows)
      cd %TRUESIGHTPSERVER_HOME%\truesightpserver\modules\pgsql\bin 

      (On Linux)

      cd /opt/bmc/TrueSightPServer/truesightpserver/modules/pgsql/bin 

   2. Run the following command:

      (On Windows)
      pg_resetxlog.exe "%TRUESIGHTPSERVER_HOME%\truesightpserver\data\pgsql"

      (On Linux)

      ./pg_resetxlog "/opt/bmc/TrueSightPServer/truesightpserver/data/pgsql"

      Note:If the following error message is displayed, run the command with -f option.

      The database server was not shut down cleanly. Resetting the transaction log might cause data to be lost.
      If you want to proceed anyway, use -f to force reset.

      (On Windows) 

      pg_resetxlog.exe -f "%TRUESIGHTPSERVER_HOME%\truesightpserver\data\pgsql"

      (On Linux)

      ./pg_resetxlog -f "/opt/bmc/TrueSightPServer/truesightpserver/data/pgsql"

   3. Start the database process by running the tssh process start database command.
      Wait for the database to restart. For more information on tssh process command, see Presentation Server tssh commands.

   4. Run the following command to confirm if the database has started. The command output should display the properties listing.
      tssh properties list
      For more information on tssh properties list, see Presentation Server tssh commands.

   5. Once the database startup is confirmed in the preceding step, restart the TrueSight Presentation Server by running the tssh server start command.

      For more information on starting the Presentation Server, see Starting-and-stopping-the-TrueSight-Operations-Management-components.

 Connecting to PostgreSQL 13.x database

1. From the Presentation Server host command prompt, go to:
   (On Windows)
   cd %TRUESIGHTPSERVER_HOME%\truesightpserver\modules\pgsql\bin 

2. Run the following command on the command prompt window:

   
   psql -U <dbUserName> -d <dbname> -h <hostname> -p <port>

   This establishes the connection with PostgreSQL 13.x database.