Red Hat Bugzilla – Bug 858055
spacewalk-setup fails with remote postgresql server
Last modified: 2012-11-01 12:23:08 EDT
Description of problem:
Using a known good postgresql remote server (not localhost) spacewalk-setup fails to populate the database. I have verified connectivity between both hosts using psql.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.install postgresql-server on one host, setup as per https://fedorahosted.org/spacewalk/wiki/PostgreSQLServerSetup
2.Install spacewalk-postgresql on another host,and attempt spacewalk-setup using IP of the DB host
psql:/usr/share/pgsql/contrib/dblink.sql:11: ERROR: could not access file "$libdir/dblink": No such file or directory
host with spacewalk-postgresql installed should have connected to DB host and setup database
You will need to install postgresql84-contrib or postgresql-contrib on your PostgreSQL server as well.
I've amended the page now: