“local” is for Unix domain socket connections only
local all all ident
IPv4 local connections:
host all all 127.0.0.1/32 trust
IPv6 local connections:
host all all ::1/128 ident
host all all 172.16.34.0/24 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:
in preparation of moving on to the latest GVM-11 release, I wanted to migrate my source-built installation from sqlite to postgres. So I installed postgres as stated in the gvmd Install.md over on GitHub and ran the gvm-migrate-to-postgres script.
The script always fails with the same error as described in the original post:
<29>Oct 16 11:59:01 gvm-migrate-to-postgres: Database version not supported: 205
It looks like my database scheme version is 205, but the migration script only covers versions up to 187:
u10013-adm@mak1-vas1:~$ sudo gvmd --version
Greenbone Vulnerability Manager 8.0.1
Manager DB revision 205
Copyright (C) 2010-2017 Greenbone Networks GmbH
License GPLv2+: GNU GPL version 2 or later
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
@ayinuha I am sorry but as I wrote before you don’t seem very familiar with building software from source code and lower-level developer/sysadmin topics in general. Therefore I highly recommend you to use packages or our community edition. Or even think about buying one of our appliances with extensive support. You are doing several beginner level mistakes for which we can’t always offer help.
A xyz.in file is a template that gets converted into the correct file during build
sorry for being a beginner, but anyway without doing i cant learn it… and for this its an forum or? if you guys cant offer always beginner help i understand it, but here are other peoples which can help too…
and just that you know, im not just very familar with building from source code, that is the first time that i make that
Of course this forum is for learning and giving advises but you did ask me directly. I am not able to answer all basic issues neither are my co-workers. You did choose a bigger and very complex product to start with. You will have to learn a lot of new things in one go and will do many many mistakes. Therefore it may be better for you to choose packages and start learning with a different simpler project.