unsupported startup parameter: statement_cache_mode

[TatyanaBol]

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]

It seems this got renamed in pgx and is now passed in as default_query_exec_mode=cache_describe

https://github.com/jackc/pgx/blob/master/conn.go