unsupported startup parameter: statement_cache_mode
TatyanaBol opened this issue · 1 comments
TatyanaBol commented
Your Question
We connect the PostgreSQL server via Pgbouncer.
Our connection string (to the Pgbouncer) contains the parameter statement_cache_mode=describe to prevent the creation of prepared statements.
After a recent upgrade
gorm.io/driver/postgres v1.3.9 => v1.5.3
gorm.io/gorm v1.23.8 => v1.25.4
our code stopped working with this error:
failed to connect to `host=pgbouncer.service user=pgbouncer_user database=metadata`: server error (FATAL: unsupported startup parameter: statement_cache_mode (SQLSTATE 08P01))
Could you please advise what this parameter should be replaced with?
The document you expected this should be explained
Expected answer
noneymous commented
It seems this got renamed in pgx and is now passed in as default_query_exec_mode=cache_describe