run stuck with ERROR: pg_stat_statements must be loaded via shared_preload_libraries (SQLSTATE 55000) | only extension created about pgcenter HOT 4 CLOSED

@grin31 You need to adjust PostgreSQL configuration -- the fact that it's present in available extensions doesn't mean that the library was loaded. Two ways to solve:

1. Edit postgresql.conf
2. ALTER SYSTEM

Then restart is required.

from pgcenter.

Fixed in master branch, will appear in next minor or patch release.

from pgcenter.

@NikolayS my workaround is:
drop extension pg_stat_statements;
in all databases

from pgcenter.

You have rare and useless configuration - pg_stat_statements extension installed in a database and empty shared_preload_libraries. As mentioned above you have two ways - enable pg_stat_statements in shared_preload_libraries and restart Postgres server, or drop extension.

Anyway, I will add proper checking of pg_stat_statements and fix this stuck. Thanks for report.

from pgcenter.