Ubuntu Question posted in
The official Ubuntu documentation can be found here.

Ubuntu – psql major version 10, server major version 16. Some psql features might not work

Remote server is running on Rocky Linux 8.9 (Green Obsidian). It had PostgreSQL 10 previously installed. This version lacks features essential to my application such as generated columns.

I uninstalled v 10 using rpm, went to the official PostgreSQL repository, and downloaded and installed version 16, which appeared to go successfully. But I get this message.

sql: /usr/pgsql-16/lib/libpq.so.5: no version information available (required by psql)
psql (10.23, server 16.2)
WARNING: psql major version 10, server major version 16.
         Some psql features might not work.

I don’t know the implications of this.

I would like to remove all remnants of v 10 but I don’t have permission for the Linux command autoremove. I want to know if this is going to be a problem down the line. Perhaps remove the operating system and install Ubuntu, which I know fully supports PostgreSQL 16

Tags:

2

Answers


  1. 0

    There’s mismatch between the psql client and PostgreSQL server versions. Your psql client is still at version 10, while your PostgreSQL server is at version 16.

    Ensure that your psql client is also upgraded to version 16. You might need to uninstall the old psql client version and install the new one. You can do this using the yum or dnf package manager with the following commands:

    sudo yum remove postgresql10
sudo yum install postgresql16

    or

    sudo dnf remove postgresql10
sudo dnf install postgresql16

    I don’t know if those are the actual package names for postgresql10 and postgresql16.

    As for removing all remnants of PostgreSQL 10, if you do this be careful with this step as it will delete all your databases and tables.

    You can use commands like these:

    sudo rm -rf /var/lib/pgsql/10/
sudo rm -rf /var/log/postgresql/
sudo rm -rf /etc/postgresql/

    And as for switching to Ubuntu, both Ubuntu and Rocky Linux support PostgreSQL 16. The choice between them should be based on your personal preference and the specific requirements of your project.

    If you’re comfortable with Rocky Linux and it meets your needs, why switch?

    Login or Signup to reply.
  2. 0

    The message is telling you your PostgreSQL server is v16, but your psql client is v10.

    Rocky (and most distros) splits PostgreSQL into several packages. Relevant here, postgresql contains the client code like psql. postgresql-server contains the server. This split lets you install the relatively small client to contact remote servers without the large server.

    You likely only upgraded the server. You also should upgrade the client package.

    You do not need to wipe the machine.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search