Still having the same issue. Fresh kali install using postgresql 12 ( never had 11 installed) and the aforementioned command returns no errors and doesn’t create said user.
From the GVMD log
Blockquote
md main:MESSAGE:2020-08-24 10h49.27 utc:286525: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage: INFO:2020-08-24 10h49.27 utc:286525: Creating user.
md manage:WARNING:2020-08-24 10h49.27 utc:286525: sql_exec_internal: PQexec failed: ERROR: cannot change name of input parameter “lvl”
HINT: Use DROP FUNCTION level_max_severity(text,text) first.
(7)
md manage:WARNING:2020-08-24 10h49.27 utc:286525: sql_exec_internal: SQL: CREATE OR REPLACE FUNCTION level_max_severity (text, text) RETURNS double precision AS ‘/usr/lib/libgvm-pg-server’, ‘sql_level_max_severity’ LANGUAGE C;
md manage:WARNING:2020-08-24 10h49.27 utc:286525: sqlv: sql_exec_internal failed
md main:MESSAGE:2020-08-24 10h49.37 utc:286527: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage: INFO:2020-08-24 10h49.37 utc:286527: Getting users.
md manage:WARNING:2020-08-24 10h49.37 utc:286527: sql_exec_internal: PQexec failed: ERROR: cannot change name of input parameter “lvl”
HINT: Use DROP FUNCTION level_max_severity(text,text) first.
(7)
md manage:WARNING:2020-08-24 10h49.37 utc:286527: sql_exec_internal: SQL: CREATE OR REPLACE FUNCTION level_max_severity (text, text) RETURNS double precision AS ‘/usr/lib/libgvm-pg-server’, ‘sql_level_max_severity’ LANGUAGE C;
md manage:WARNING:2020-08-24 10h49.37 utc:286527: sqlv: sql_exec_internal failed
Blockquote
any other thoughts ?