Gvm-migrate-to-postgres: Database version not supported

good afternoon

I installed the greenbone-vulnerability-manager on the Centos 7 operating system successfully

command executed

yum install greenbone-vulnerability-manager

sed -i ‘/^#.*unixsocket/s/^# //’ /etc/redis.conf

systemctl enable redis && systemctl restart redis

echo ‘OPTIONS="–listen= --port=9392"’ > /etc/sysconfig/gsad

systemctl start gsad


I need to migrate the sqlite database to postgres, but it was not possible, I request support

database installation procedure

yum install postgresql-server postgresql postgresql-contrib

  • Versions installed

postgresql-setup initdb

systemctl enable postgresql ; systemctl start postgresql

sudo -u postgres bash

createuser -DRS openvas10

createdb -O openvas10 gvmd

sudo -u postgres bash

psql gvmd

create role dba with superuser noinherit;

grant dba to openvas10;

sudo -u postgres bash

psql gvmd

create extension “uuid-ossp”;

createuser -DRS root

grant dba to root;

ALTER USER root with password ‘password’;

vim /var/lib/pgsql/data/postgresql.conf

listen_addresses = ‘*’

vim /var/lib/pgsql/data/pg_hba.conf


“local” is for Unix domain socket connections only

local all all ident

IPv4 local connections:

host all all trust

IPv6 local connections:

host all all ::1/128 ident

host all all trust

systemctl restart postgresql


gvm-migrate-to-postgres: Checking SQLite3 database.
gvm-migrate-to-postgres: SQLite: DROP INDEX report_hosts_by_host;
gvm-migrate-to-postgres: SQLite: CREATE INDEX report_hosts_by_host ON report_hosts (host);
gvm-migrate-to-postgres: SQLite: PRAGMA integrity_check;
gvm-migrate-to-postgres: PG: SELECT EXISTS (SELECT table_name FROM information_schema.tables WHERE table_catalog = ‘gvmd’ AND table_schema = ‘public’ AND table_name = ‘meta’) ::integer;
gvm-migrate-to-postgres: Database version not supported:

What do I need to do to correct the problem?

Thank you in advance for your attention.



it’s very likely that you have a too old version of OpenVAS. You have to update at best to the latest gvmd 9 release (GVM-9 (old stable, initial release 2017-03-07)) first.

Good Morning,

I made the installation through the atomic repository
yum install greenbone-vulnerability-manager 10.0.0-6947.el7.art

below installed versions

gvmd --version

Greenbone Vulnerability Manager 8.0.0
DB Manager revision 205

openvassd --version

OpenVAS Scanner 6.0.0
Most new code since 2005: © 2018 Greenbone Networks GmbH

gsad --version

Greenbone Security Assistant 8.0.0
Copyright © 2010-2016 Greenbone Networks GmbH

psql --version

psql (PostgreSQL) 9.2.24

sqlite3 --version

3.7.17 2013-05-20 00:56:22

Do I need to upgrade? What’s the procedure?


Please get back to Atomic, we can´t support any 3rd party packets here. You need either psql or sqlite so both are not simultaneously needed, please ensure that GVM is build with PSQL support as well.

I would suggest to build it from the source with the last GVM 10 release and not relay to 3rd party packets that are known to be buggy or insecure.


would have some manual for compiling the solution with postgres in Centos 7?


Yes you need to go to our github and under “installation and usage” is described how to build the software.

You should be familiar with your Linux system …