Red Hat Bugzilla – Bug 822115
spacewalk-setup on CentOS Postgres not working
Last modified: 2012-11-01 12:23:05 EDT
Description of problem:
The script has several issues. The documentation states that the only prerequisite is to have a database account having a password set. This misses that a database must exist (CREATE DATABASE xxx;).
When I execute spacewalk-setup it will fail to populate db because there is no Language plpgsql. Therefore I switched to psql and created the language with
CREATE LANGAUGE plpgsql;
Then i try again and this time the populate log will tell me 'relation xyz already exists'. I therefore delete the database and the language und recreate them. The next attempt I will get the 'no language plpgsql' error again (despite created as found in pg documentation)
Version-Release number of selected component (if applicable):
Failed to populate database.
I therefore think either there is a bug in 'spacewalk-setup' or the HowToInstall is missing some steps specific for postgres when it comes to the language.
In order to get Spacewalk to run with PostgreSQL database backend, you need PostgreSQL 8.4 server installed on the same or different machine. Use PostgreSQLServerSetup as a guide to get the server installed and setup.
and the https://fedorahosted.org/spacewalk/wiki/PostgreSQLServerSetup gives step by step instructions, addressing all issues you mention.