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:
Fixed with https://github.com/openshift/origin-server/pull/656
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