Installing OpenVAS on Kali / Debian problem with PostgreSQL version

Question

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?

score 11 · Accepted Answer · answered Apr 21 '21 at 21:22

gvm-setup will look for PostgreSQL on port 5432. If you have more than one version of PostgreSQL installed, they will be assigned incremental port numbers starting at 5432. To check for other versions of PostgreSQL, you can look in the /etc/postgresql/ directory. You may see multiple directories, corresponding to the PostgreSQL versions you have installed.

You should go into each version and edit the postgresql.conf file to change the port number of PostgreSQL 13 to 5432, and assign other port numbers to the other versions. So if you had PostgreSQL 12 and 13 installed:

Edit the PostgreSQL 12 config file

$ nano /etc/postgresql/12/main/postgresql.conf

find the line port = 5432 and change to:

port = 5433

Edit the PostgreSQL 13 config file

$ nano /etc/postgresql/13/main/postgresql.conf

find the line port = 5433 and change to:

port = 5432

Finally restart PostgreSQL:

systemctl restart postgres

and then run gvm-setup again

gvm-setup

Works perfectly just had to move from 13->14 if you have the same case just set the config port to the `5432` and it'll work! — Moussa Bistami, Apr 30 '22 at 02:59

score 2 · Answer 2 · answered May 23 '22 at 11:46

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:

delete automatically generated cluster version 14 (use --stop if service status is not down):
```
sudo pg_dropcluster --stop 14 main
```
migrate cluster version 13 to version 14:
```
 sudo pg_upgradecluster 13 main
```
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.

Installing OpenVAS on Kali / Debian problem with PostgreSQL version

2 Answers2