Bug 865087

Summary:	The PostgreSQL cartridge is missing postgresql-contrib
Product:	OKD	Reporter:	Jan Pazdziora <jpazdziora>
Component:	Containers	Assignee:	Mrunal Patel <mpatel>
Status:	CLOSED CURRENTRELEASE	QA Contact:	libra bugs <libra-bugs>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	2.x	CC:	jhou, mpatel, wsun
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	devenv_2319+	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-11-06 18:50:23 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:

Description Jan Pazdziora 2012-10-10 19:28:42 UTC

Description of problem:

I try to use the dblink PostgreSQL extension but

  \i /usr/share/pgsql/contrib/dblink.sql

in psql fails -- presumably the postgresql-contrib package is not installed on the Openshift host. It should be as it adds important functionality to the PostgreSQL server.

Version-Release number of selected component (if applicable):

PostgreSQL 8.4 cartridge.

How reproducible:

Tried on one application.

Steps to Reproduce:
1. Start psql.
2. Try to define dblink in your database with

\i /usr/share/pgsql/contrib/dblink.sql
  
Actual results:

test1=# \i /usr/share/pgsql/contrib/dblink.sql
/usr/share/pgsql/contrib/dblink.sql: No such file or directory
test1=#

Expected results:

No error, dblink functions created.

Additional info:

Comment 1 Mrunal Patel 2012-10-11 19:26:04 UTC

Fixed with https://github.com/openshift/origin-server/pull/656

Comment 2 Jianwei Hou 2012-10-15 02:27:18 UTC

Verified on devenv_2327

Steps:
1. Create app and embed postgresql
2. SSH into app and start psql
3. Try to define dblink in database

Result:
Dblink functions created without error.

php1=# \i /usr/share/pgsql/contrib/dblink.sql
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
REVOKE
REVOKE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION