| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | KK CHN <kkchn(dot)in(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PgBouncer Prepared Statement ERROR |
| Date: | 2025-07-18 13:34:28 |
| Message-ID: | cec6a7f06cfa787e643ef0c0aa73ecd685e79e06.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-07-18 13:40:06 | Re: Regarding logical replication issues with PostgreSQL versions 16 and above |
| Previous Message | Greg Sabino Mullane | 2025-07-18 13:32:29 | Re: PgBouncer Prepared Statement ERROR |