Try
Home   >   mailing lists

Re: PgBouncer Prepared Statement ERROR - Mailing list pgsql-general

From Laurenz Albe
Subject Re: PgBouncer Prepared Statement ERROR
Date
Msg-id cec6a7f06cfa787e643ef0c0aa73ecd685e79e06.camel@cybertec.at
Whole thread Raw
In response to PgBouncer Prepared Statement ERROR  (KK CHN <kkchn.in@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: PgBouncer Prepared Statement ERROR
Next
From: Laurenz Albe
Date:
Subject: Re: Regarding logical replication issues with PostgreSQL versions 16 and above