postgrespro/pg_wait_sampling

collector wasn't starting

TezkaRabota opened this issue · 1 comments

Hi,
I have problem with pg_wait_sampling extension on Postgresql-11.8-1. I want to use it with PoWA, but I get an error: : powa_take_snapshot(0): function "powa_wait_sampling_snapshot" failed: pg_wait_sampling collector wasn't started.
How should I start pg_wait_sampling extension. I installed it using following procedure (on Centos 7):
yum install pg_wait_sampling_11
shared_preload_libraries = 'pg_stat_statements,pg_wait_sampling'
CREATE EXTENSION pg_wait_sampling;

I also try to install last version of extension from scratch, but the result was the same.

Select on pg_wait_sampling_current view gives data. But select on pg_wait_sampling_history and pg_wait_sampling_profile give an error: "ERROR: pg_wait_sampling collector wasn't started
SQL state: XX000".

What am I doing wrong?
Regards

Domen

Problem solved. Postgresql parameter max_worker_processes was to low.