Database Import Into New Install

GVM versions

gsad: (‘gsad --version’) 21.4.3
gvmd: (‘gvmd --version’) 21.4.4
openvas-scanner: (‘openvas --version’, in older GVM versions < 11: ‘openvassd --version’) 21.4.3
gvm-libs: 21.4.3

Environment

Operating system: Debian 10
Kernel: (‘uname -a’) Linux openvas 4.19.0-18-amd64 #1 SMP Debian 4.19.208-1 (2021-09-29) x86_64 GNU/Linux

Installation method / source: Followed guide from greenbone.net

Hi All,

Despite many attempts to upgrade 20.08 to 21.04, I decided to build a new system with a clean install of 21.04 instead. What is the best way to import the db into the new install? I exported the db from the old system by stopping all of the services and doing a pg_dump. When I drop the new gvmd db after install, recreate it, and import the .sql file, I get random errors and gvmd doesn’t start.

Any advice is greatly appreciated!

Thanks,

-Mike

You didn’t mention it, so I’ll ask …
Did you run gvmd --migrate before starting gvmd ?

1 Like

Here is what I get when I run gvmd --migrate

(gvmd:23483): md manage-WARNING **: 09:21:30.984: Failed to open lock file ‘/run/gvm/gvm-create-functions’: No such file or directory

Is there another way to get more verbose output from the migrate option?

We can put this one to bed. I created /run/gvm with the owner gvm. When I ran the import it errored out. Once I granted gvm some higher permissions in PGSQL, the migration seems to be running ok. Just had to hack through it all :slight_smile:

3 Likes