pghero on PostgresApp pg_stat_statements must be loaded via shared_preload_libraries

Question

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?

You can check which config file your server is using through `show config_file;` — , Jan 26 '15 at 09:13
that gives me `/Library/PostgreSQL/9.3/data/postgresql.conf` which doesn't exist... — Nick Ginanto, Jan 26 '15 at 09:24
@a_horse_with_no_name that command displayed my mistake. I've been changing the wrong conf file. — Celal Ergün, Jun 10 '20 at 15:11

score 61 · Answer 1 · edited Jun 08 '20 at 08:00

61

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.

edited Jun 08 '20 at 08:00

Patryk Kotarski

answered Jun 09 '16 at 14:24

Martin Seener

2

This duplicates the answer of @compyutech, doesn't it? – Markus Jun 09 '16 at 14:31
4

Wanted to state clearly that a restart is necessary before one can use the extension and no one said that before. otherwise yes, its duplicate if that not an important information – Martin Seener Jun 09 '16 at 14:35
1

just creating the extension without editing shared_preload_libraries in postgresql.conf didn't work for me, that's why it's not duplicate – Sardorkhuja Tukhtakhodjayev Jan 31 '23 at 11:59

score 2 · Answer 2 · answered Jan 12 '16 at 05:35

2

Create extension by executing following query

CREATE EXTENSION pg_stat_statements

answered Jan 12 '16 at 05:35

compyutech

1

This error occurs AFTER the extension has already been created... – Douglas Gaskell Oct 01 '22 at 01:44

2 Answers2