On Wed, Jun 29, 2011 at 08:32:29AM +0200, Jonathan Hoser wrote:
> Hi all,
>
> I was just about to do a fresh spacewalk 1.4 on a virtualized centos
> using a remote Postgres database,
> when I hit an issue:
>
> The populating of the database (spacewalk setup) failed, because the
> language 'plpgsql' was not setup;
> fun thing is, the Postgres installation I am using for this experiment
> actually already is hosting my current live-spacewalk system,
> only in a different database.
>
> By adding the basic two lines (from the Postgres manual) to my
> /etc/sysconfig/rhn/postgres/main.sql I actually got it working:
>
> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS
> '$libdir/plpgsql' LANGUAGE C;
>
> CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql
> HANDLER plpgsql_call_handler;
>
> I don't know why this issue surfaced when it did -
> maybe this is something that only happens on remote-postgresql
> installations, as I haven't noticed it before.
We list this on the
https://fedorahosted.org/spacewalk/wiki/PostgreSQLServerSetup
page. I assume you created the database and user in the cluster
manually but forgot about the language.
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
