'Installing OpenVAS on Kali / Debian problem with PostgreSQL version

After installing OpenVAS on Kali linux, ran gvm-setup command to setup GVM as per instructions: https://linuxhint.com/install-openvas-kali-linux/

However, the following error ocurred:

ERROR: The default postgresql version is not 13 required by libgvmd
Error: Use pg_upgradecluster to update your postgres cluster

So, I checked the version of PostgreSQL installed by:

$ su postgres
$ psql --version
psql (PostgreSQL) 13.2 (Debian 13.2-1)

The version was 13. How can I complete the gvm-setup?

postgresqlopenvasplotlyfacetplotly-python


Solution 1:[1]

The error message tells you, that you should upgrade your postgres cluster. There could already be a higher version of postgres cluster created in your system, which you can examine with the following command:

sudo pg_lsclusters

However, this auto generated cluster might not always function as intended (e.g. it operates on different from default port). Thus, it's best to perform manual cluster upgrade (you can omit step 1 if you don't have any auto generated cluster). Assuming that you want to upgrade from version 13 to 14:

  1. delete automatically generated cluster version 14 (use --stop if service status is not down):

    sudo pg_dropcluster --stop 14 main

  2. migrate cluster version 13 to version 14:

     sudo pg_upgradecluster 13 main

  3. optionally, you can drop the old cluster:

     sudo pg_dropcluster --stop 13 main

That's it! The new cluster will listen on the port, that were previously used by the old cluster. It might be needed to start or enable postgres service in systemd in order to use PostgreSQL in other applications.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 dist3r

Related Questions