Horton

Re: PgBouncer Prepared Statement ERROR

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: KK CHN <kkchn.in@gmail.com>, pgsql-general@lists.postgresql.org
Date: 2025-07-18T13:34:28Z
Lists: pgsql-general 
On Fri, 2025-07-18 at 18:22 +0530, KK CHN wrote:
> I am getting error when using  PgBouncer(1.23.1 ) with  Postgres 16  (RedHAT 9.4)
> 
> 2025-07-18 00:00:00 IST ERROR:  prepared statement "S_243" does not exist
> 2025-07-18 00:00:03 IST ERROR:  prepared statement "S_205" does not exist
> 2025-07-18 00:00:03 IST ERROR:  prepared statement "S_206" does not exist
> 2025-07-18 00:00:03 IST ERROR:  prepared statement "S_207" does not exist
> 
> How to avoid these prepared statement Errors ? 

Use a recent version of pgBouncer and set "max_prepared_statements"
high enough.

Yours,
Laurenz Albe