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.
Just wanted to share it with you,
best
-Jonathan
--
Jonathan Hoser
Institute of Bioinformatics and System Biology
Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
