CODEWITHSUNDEEP
postgresqllibraries
shivam
shivam

Reputation: 53

Shared_preload_libraries in postgresql

Shared Library Preloading -

shared_preload_libraries = 'pg_stat_statements' # (change requires restart)

After changing this I restart the server also but no change reflected in the system.

Also, create an extension.

ERROR-SQL Error [55000]: ERROR: pg_stat_statements must be loaded via shared_preload_libraries

Upvotes: 3

Views: 8368

Answers (2)

RPA Developer
RPA Developer

Reputation: 16

After restart your server you need to enable extension. After that you can query pg_stat_statements. Check documentation https://www.postgresql.com/docs/current/pgstatstatements.html

CREATE EXTENSION pg_stat_statements;

Upvotes: 0

Sevak
Sevak

Reputation: 11

In my case it was overridden by the other config file named "60_extensions.conf" from "/var/lib/pgsql/14/data/conf.d" directory. I got it from the "sourcefile" column from this query "select * from pg_settings where name = 'shared_preload_libraries' "

Upvotes: 1

Related Questions