Installation and Startup Failure of Postgres Database in some Linux Distributions

Installation and Startup Failure of Postgres Database in some Linux Distributions


Log Traces 
  1. Jul 27, 2023 6:24:49 PM  [SYSOUT]  [INFO] : /home/sdpuser/ManageEngine/ServiceDesk/pgsql/bin/psql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

Root Cause 
  1. libtinfo.so is a shared library that provides terminal information handling functionality. It is part of the GNU C Library (glibc) and is used for terminal-related operations, such as handling terminal capabilities, terminal size, and terminal input/output.
  2. From the trace, it seems like the library could not be accessed. either it should be missing or corrupted or restricted.
WorkAround 
  1. As mentioned in the above points, this library is required for the successful installation and startup. you can install the package using the below command.
    1. sudo yum install ncurses-compat-libs
  2. If you had already installed, but still this issue persist, which implies that the required version of library is not found. In this case,  you can follow any one of the below two procedure after locating the 'libtinfo.so' package in your machine, using the command " locate libtinfo.so".
    1. Duplicate and Rename
      1. Make a copy of the file which is named "libtinfo.so.<x>" (For Example, libtinfo.so.6) in the same directory.
      2. Rename the copied file to "libtinfo.so.5"
    2. Make a symlink for the file.
      1. sudo ln -s <path of the located file> <same path of the located file, but rename the filename to "libtinfo.so.5">
        1. For Example,
          1. sudo ln -s /usr/lib/x_64/libtinfo.so.6 /usr/lib/x_64/libtinfo.so.5
  3. After this procedure, Kindly try to start the server. If the same issue persist, Kindly collect the logs and report it to our support team.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Migration failure for Postgres Database with a blank space in it

                        Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...
                      • Postgres Database startup failures with InitPgsql error trace

                        [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [SEVERE] : Please login to the system as <machine_name>\Administrator and execute initPgsql.bat script with administrator privileges. If issue is not yet solved, please contact support ...
                      • How to Connect External Postgres

                        Install a External Postgres such that the version of that postgres is currently in the series of inbuilt postgres of our Application. Say for example, In Servicedeskplus Application version 14010, which has postgres version 10.21, then you should ...
                      • How to resolve Connectivity issues with Postgresql Database from our product?

                        Log Traces Feb 20, 2024 6:40:00 PM [SYSERR] [INFO] : java.sql.SQLException: java.lang.Exception: Exception during getConnection from pool Exception occurred during get connection from datasource Nov 15, 2023 1:29:10 PM [SYSERR] [INFO] : Caused by: ...
                      • su: cannot open session: Module is unknown

                        The upgrade issue arises in several linux editions such as RHEL and CentOS when the bundled postgres database needs to be upgraded in that particular patch and the upgrade is triggered by the root user. The highlighted line in the traces below (su: ...