Verify this bug with openshift-origin-cartridge-postgresql-1.32.4.1-1.el6op 1. Create an app with postgresql-9.2 embedded. 2. Set the OPENSHIFT_POSTGRESQL_CONFIG variable with below value: rhc set-env OPENSHIFT_POSTGRESQL_CONFIG="shared_preload_libraries = 'pg_stat_statements';pg_stat_statements.track = all" -a test1 3. Restart the app 4. Checked the environement variable has changed [test1-123.ose22-manual.com.cn 123-test1-1]\> printenv OPENSHIFT_POSTGRESQL_CONFIG shared_preload_libraries = 'pg_stat_statements';pg_stat_statements.track = all 5. Ran command requested in psql test1=# \i /usr/share/pgsql/contrib/pg_stat_statements.sql SET CREATE FUNCTION CREATE FUNCTION CREATE VIEW GRANT REVOKE test1=# select * from pg_stat_statements; userid | dbid | query | calls | total_time | rows --------+-------+------------------------------------------------------------ -----------+-------+------------+------ 10 | 12923 | SELECT d.datname as "Name", +| 1 | 0.439 | 4 | | pg_catalog.pg_get_userbyid(d.datdba) as "Owner", +| | | | | pg_catalog.pg_encoding_to_char(d.encoding) as "Encod ing", +| | | | | d.datcollate as "Collate", +| | | | | d.datctype as "Ctype", +| | | | | pg_catalog.array_to_string(d.datacl, ?) AS "Access p rivileges"+| | | | | FROM pg_catalog.pg_database d +| | | | | ORDER BY 1; | | | (1 row)
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHBA-2015-0779.html