This enhancement adds the OPENSHIFT_POSTGRESQL_CONFIG environment variable for the PostgreSQL cartridge, which allows developers to specify additional configuration lines for inclusion in the postgresql.conf file. For example, developers can now use this environment variable to enable execution statistics:
# rhc set-env OPENSHIFT_POSTGRESQL_CONFIG="shared_preload_libraries = 'pg_stat_statements';pg_stat_statements.track = all"
Note the required ";" separating each setting when listing multiple configuration lines. After applying this update, a cartridge upgrade is required. If enabling execution statistics, developers must also restart their application after setting OPENSHIFT_POSTGRESQL_CONFIG.
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
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)