[Spacewalk-list] migration problems

[Michael Mraka]

Konstantin Raskoshnyi:
> Hi guys,
> After I migrated from postgres 8x to 9.5 I see these problems when I try to
> change config channels
> 
> SEVERE: Servlet.service() for servlet [action] in context with path [/rhn]
> threw exception [javax.servlet.jsp.JspException: Error writing to JSP
> file:] with root cause
> org.postgresql.util.PSQLException: ERROR: function dblink_connect(unknown,
> text) does not exist
>   Hint: No function matches the given name and argument types. You might
> need to add explicit type casts.
>   Where: PL/pgSQL function pg_dblink_exec(character varying) line 6 at
> PERFORM
> SQL statement "SELECT pg_dblink_exec(
>                 'insert into rhnConfigFileName (id, path) values (' ||
> 
> 
> Any thoughts?

Hi Konstantin,

You need dblink extension in your postgresql.
It can be fixed manually by

# echo "create extension dblink;" | spacewalk-sql -
 

> PS When I did spacewalk-schema-upgrade it failed with some errrors, I
> believe this is the root cause,
> Sp has the same version
> 
> Thanks

Regards,

--
Michael Mráka
System Management Engineering, Red Hat