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): 1.8 How reproducible: Everytime. 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 3. Actual results: SET psql:/usr/share/pgsql/contrib/dblink.sql:11: ERROR: could not access file "$libdir/dblink": No such file or directory Expected results: host with spacewalk-postgresql installed should have connected to DB host and setup database Additional info:
You will need to install postgresql84-contrib or postgresql-contrib on your PostgreSQL server as well. I've amended the page now: https://fedorahosted.org/spacewalk/wiki/PostgreSQLServerSetup#Thecontribpackage