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.pirvu@gmail.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