Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17136: set shared_preload_libraries = 'pg_stat_statements,pg_prewarm,pg_trgm' , postgresql Cannot Startup - Mailing list pgsql-bugs

From Julien Rouhaud
Subject Re: BUG #17136: set shared_preload_libraries = 'pg_stat_statements,pg_prewarm,pg_trgm' , postgresql Cannot Startup
Date
Msg-id CAOBaU_adV4yJpd8B4xNsf1jrHvDJ3rYaU9St9c54C+9+nnETEg@mail.gmail.com
Whole thread Raw
In response to BUG #17136: set shared_preload_libraries = 'pg_stat_statements,pg_prewarm,pg_trgm' , postgresql Cannot Startup  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
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/

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3
Next
From: Andrey Borodin
Date:
Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data