powa isnt getting enabled in shared_preload_libraries

[sajiljosephs]

in postgresql.conf shared_preload_libraries = 'pg_stat_statements,powa,pg_stat_kcache,pg_qualstats,pg_wait_sampling'

show shared_preload_libraries; pg_stat_statements, pg_qualstats, pg_stat_kcache

select count(*) from pg_stat_statements; 1080

screenshots clearly says that all required extensions are enabled.

[rjuju]

Hi,

I'm not entirely sure of what your problem is. If the problem is "Collector status for this instance: stopped" and the "stopped" status in the servers page, the reason is that powa.frequency is set to -1, which means "no local snapshot". If you want to use the local mode (a single server for your data and powa data), then you need to choose a positive value for powa.frequency. A good general value is '5min' to get decent granularity without much overhead.

[sajiljosephs]

background worker is not connected. On checking could see that powa is not getting enabled with shared_preload_libraries As it is not enabled, powa.frequency cannot be set in postgresql.conf

[sajiljosephs]

[rjuju]

On checking could see that powa is not getting enabled with shared_preload_libraries

Do you mean that when doing "SHOW shared_preload_libraries;" powa doesn't appear? Did you restart postgres after configuring shared_preload_libraries?

[sajiljosephs]

Yes, restarted postgres many times. powa doesnt appear with "SHOW shared_preload_libraries;"

[rjuju]

Then the shared_preload_libraries is being configured from somewhere else. Maybe someone used ALTER SYSTEM, or you have the same setting configured later in the same file or an included file. You can check where the setting is actually coming from using:

SELECT name, setting, source, sourcefile, sourceline FROM pg_settings WHERE name = 'shared_preload_libraries';

Modify the really used file and restart and the new value should be applied.

[sajiljosephs]

Perfect, Thanks for helping out.

[rjuju]

Great news!