Articles in this section

Error after installing/updating PostgreSQL on a Plesk server: '/lib64/libpq.so.5: no version information available'

Kuzma Ivanov
Updated
Plesk for Linux

Applicable to:

  • Plesk for Linux

Symptoms

  • After a manual installation/update of PostgreSQL, the following error appears for tasks that involve sw-engine:

    CONFIG_TEXT: /usr/bin/sw-engine: /lib64/libpq.so.5: no version information available (required by /usr/bin/sw-engine)

  • libpq5 package is supplied by PostgreSQL Global Development Group:

    # rpm -qi libpq5 | grep Vendor
    Vendor      : PostgreSQL Global Development Group

Cause

During the manual installation/update of PostgreSQL, an incompatible version of the libpq library was installed.

Resolution

  1. Connect to your Plesk server via SSH.

  2. Remove the libpq5 package without dependencies:

    # rpm -e --nodeps libpq5

  3. Find the repository name from which libpq5 package was installed:

    # yes n | yum install libpq5 | grep libpq5 | awk '{print $4}'

    In the example below, it is pgdg-common:

    # yes n | yum install libpq5 | grep libpq5 | awk '{print $4}'
    Operation aborted.
    pgdg-common

  4. Locate the file with this repository:

    # grep -ir pgdg-common /etc/yum.repos.d/

    In the example below, the file is /etc/yum.repos.d/pgdg-redhat-all.repo:

    # grep -ir pgdg-common /etc/yum.repos.d/
    /etc/yum.repos.d/pgdg-redhat-all.repo:[pgdg-common]

  5. Open the file from step 4 in a text editor. In this example, we are using vi editor:

    # vi /etc/yum.repos.d/pgdg-redhat-all.repo

  6. In the [pgdg-common] section, add the following line:

    CONFIG_TEXT: exclude=libpq*

  7. Save the changes and close the file.

  8. Install libpq5 from the system repository:

    # yum install libpq

  9. Verify that sw-engine no longer produces errors:

    # sw-engine -v

Was this article helpful?

Comments

1 comment
Date Votes

Please sign in to leave a comment.