Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 858055

Summary:	spacewalk-setup fails with remote postgresql server
Product:	[Community] Spacewalk	Reporter:	Abel Lopez <alopgeek>
Component:	Installation	Assignee:	Jan Pazdziora (Red Hat) <jpazdziora>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	1.8	CC:	jpazdziora
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-09-24 12:27:33 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	871344

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