Re: shared_preload_libraries and pg_stat_statements

Hi Tom

Thank you

That did it, darn files.

Back in business so to speak

Armand

On Sep 4, 2015, at 3:18 PM, Tom Lane wrote:

> "Armand Pirvu (gmail)" <armand(dot)pirvu(at)gmail(dot)com> writes:
>> In my postgresql.conf I have
>
>> shared_preload_libraries = 'pg_stat_statements, pg_shard' # (change requires restart)
>> pg_stat_statements.max = 10000
>> pg_stat_statements.track = all
>
>> The server restarts ok, created the extension fine, but
>
>> postgres=# select * from pg_stat_statements;
>> ERROR: pg_stat_statements must be loaded via shared_preload_libraries
>
>> And more
>
>> postgres=# SHOW shared_preload_libraries;
>> shared_preload_libraries
>> --------------------------
>> pg_shard
>> (1 row)
>
> I'd say either you edited the wrong config file ("select * from
> pg_settings where name = 'shared_preload_libraries'" might help
> debug that), or you failed to restart the server (this change
> requires an actual stop and restart, not just reload config).
>
> regards, tom lane