search

go-gorm / postgres

GORM PostgreSQL driver
MIT License
228 stars 120 forks source link

unsupported startup parameter: statement_cache_mode #219

Open TatyanaBol opened 11 months ago

TatyanaBol commented 11 months ago

Your Question

We connect the PostgreSQL server via Pgbouncer. Our connection string (to the Pgbouncer) contains the parameter _statement_cachemode=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 8 months ago

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