Обсуждение: BUG #17136: set shared_preload_libraries = 'pg_stat_statements,pg_prewarm,pg_trgm' , postgresql Cannot Startup

Поиск
Список
Период
Сортировка

BUG #17136: set shared_preload_libraries = 'pg_stat_statements,pg_prewarm,pg_trgm' , postgresql Cannot Startup

От
PG Bug reporting form
Дата:
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/