No SCAP database found, please help me

gpgp01 · August 31, 2023, 7:50pm

HELLO to all,
i have solved the problema:

su - postgres
psql gvmd
gvmd=# \dn

List of schemas
  Name  |       Owner
--------+-------------------
 cert   | _gvm
 public | pg_database_owner
 scap   | postgres
 scap2  | _gvm
(4 rows)

Owner scap schemas is postgres instead of _gvm

ALTER SCHEMA scap OWNER TO _gvm;

gvmd=# \dn
      List of schemas
  Name  |       Owner
--------+-------------------
 cert   | _gvm
 public | pg_database_owner
 scap   | _gvm
 scap2  | _gvm
(4 rows)

thanks