BUG #17136: set shared_preload_libraries = 'pg_stat_statements,pg_prewarm,pg_trgm' , postgresql Cannot Startup
The following bug has been logged on the website:
Bug reference: 17136
Logged by: 强 魏
Email address: 1726002692@qq.com
PostgreSQL version: 14beta2
Operating system: CentOS 7.6.1810
Description:
When setting shared_ preload_libraires='pg_state_statement', PostgreSQL
cannot be started .
ErrorCode:FATAL: could not access file "pg_statements":There is no such
file or directory
PG Version 13 IS OK .
On Fri, Aug 6, 2021 at 8:28 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
When setting shared_ preload_libraires='pg_state_statement', PostgreSQL
cannot be started .
ErrorCode:FATAL: could not access file "pg_statements":There is no such
file or directory
Your message mentioned both pg_stat_statements, pg_state_statements
and pg_statements. It seems to me that what you used in your
configuration file is pg_statements rather than pg_stat_statements,
which is why it's not working.
This is not a bug but a configuration error. Please instead send a
message to the pgsql-general mailing list if you need help to
configure postgres: https://www.postgresql.org/list/pgsql-general/