Bug 858055 - spacewalk-setup fails with remote postgresql server
Summary: spacewalk-setup fails with remote postgresql server
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Installation
Version: 1.8
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Jan Pazdziora (Red Hat)
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space18
TreeView+ depends on / blocked
 
Reported: 2012-09-17 21:47 UTC by Abel Lopez
Modified: 2012-11-01 16:23 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2012-09-24 12:27:33 UTC
Embargoed:

Attachments (Terms of Use)

Description Abel Lopez 2012-09-17 21:47:29 UTC 
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:
Comment 1 Jan Pazdziora (Red Hat) 2012-09-24 12:27:33 UTC 
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
Note You need to log in before you can comment on or make changes to this bug.