pghero on PostgresApp pg_stat_statements must be loaded via shared_preload_libraries

postgresql rails-postgresql
Nick Ginanto picture Nick Ginanto · Jan 26, 2015 · Viewed 13.6k times · Source

I have this error 

  PG::ObjectNotInPrerequisiteState: ERROR:  pg_stat_statements must be loaded via shared_preload_libraries

on localhost. Using osx (10.9.5), PostgresApp 9.3.1.0 and pghero gem

Going to postgresql.conf located in ~/Library/Application Support/Postgres93/var I have this in the top of the file 

shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all

So, either this is the correct postgresql.conf, or something in my setup is broken..

Any ideas?

Answer

Martin Seener picture Martin Seener · Jun 9, 2016

You have to restart the Postgresql Server in order to load the shared library and afterwards execute

CREATE EXTENSION pg_stat_statements;

in the database you want to monitor.

Additionally you will have to edit the following line in postgresql.conf

shared_preload_libraries = ''

To

shared_preload_libraries = 'pg_stat_statements'

A restart of the PSQL service is required.

Related questions

Can't find the 'libpq-fe.h header when trying to install pg gem

I am using the Ruby on Rails 3.1 pre version. I like to use PostgreSQL, but the problem is installing the pg gem. It gives me the following error: $ gem install pg Building native extensions. This could take a while... ERROR: …

Read More
How to solve privileges issues when restore PostgreSQL Database

I have dumped a clean, no owner backup for Postgres Database with the command pg_dump sample_database -O -c -U Later, when I restore the database with psql -d sample_database -U app_name However, I encountered several errors …

Read More
PostgreSQL date() with timezone

I'm having an issue selecting dates properly from Postgres - they are being stored in UTC, but not converting with the Date() function properly. Converting the timestamp to a date gives me the wrong date if it's past 4pm PST. 2012…

Read More