Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uclD5-00Gmq7-Bj for pgsql-general@arkaria.postgresql.org; Fri, 18 Jul 2025 13:33:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uclD2-00CXTG-W9 for pgsql-general@arkaria.postgresql.org; Fri, 18 Jul 2025 13:33:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uclD2-00CXT7-Lh for pgsql-general@lists.postgresql.org; Fri, 18 Jul 2025 13:33:09 +0000 Received: from mail-il1-x134.google.com ([2607:f8b0:4864:20::134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uclD1-007x8O-1l for pgsql-general@lists.postgresql.org; Fri, 18 Jul 2025 13:33:08 +0000 Received: by mail-il1-x134.google.com with SMTP id e9e14a558f8ab-3e28bf4a350so11177555ab.1 for ; Fri, 18 Jul 2025 06:33:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752845586; x=1753450386; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=DQzUPPzWIr5teDj2bLQx3V9R1lzeq419/DpEaRGbvVg=; b=QLBq599+KqY5zVRhddAMx6zMJ1VC+9p6sKjx2JwwyRrCE/mYtRy8NsRjEInsJx5ab8 bahhL2uQGrbeaoMF1eXVTrOk7rnFS+JUD0DCbdWPRWJJ+XlGdTahoo3iAybcF9s2nXPx iUxKsH9qipGI4IJRt71WJ/ufGRUqeRdxznUMTQFq0Tqpq6QZ9QCtuLY53YiCb4aYcQqy pCihsUdjnYWwejUNOv2VzIBXbeZ0TAdNEaNMbRJ/eK/rBjG0ID2AN1Lt6uQnTWMvUh5p 13U9apxXHA7m8X+w59r3fet0ZT14XnnN6WFYEK27UshptszhvNCq5A0UGKpBSNj2WfIU TsFA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752845586; x=1753450386; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=DQzUPPzWIr5teDj2bLQx3V9R1lzeq419/DpEaRGbvVg=; b=ZFsobY/OCWRNB2HTRoTnBEZTtsZ2xgDugyF0hcYn+qIRS9Wg07oaOFYRGa0b4UzFhm /zxr24AF7qvKf91/961YMTqcXKOv8CE2ExYT6s2OhutOi9feha3lXRdaQbx6l2NAC6qD d8gIQqwl89JNvYLbtg5lUQ5GHsTvtCqxFJuWMl27qhAHptB3+wR5ZAcQNsrhRiZ3lCNm ZK4DkJk+7oS0mR12ibR6j48Nqfm9gq4mR/3TkzLWysFGnYIsdXdRKUC96aq83Yipz44H xqIHOFB2AlEF3Wq91Vlyv/mrYNdBIp75vlOYqGu8bHHqfbTykfzEUCsB3gJIeAX1s9DF mnHw== X-Gm-Message-State: AOJu0YzRwj2ExwHLpl5i5pgUdUhqCcAW6i0f67HefRtOukvhuVY2j03H +H7VC/UP16J+KDe30YPjHmoiExUv9CoizO2Cg/GDhJ71zhjDhI6hup8Gt+b9vw/UtrlLQ0MMYWP L4uWjA5q8spVDFyacbP2wUI47Y6nG9g8HQX1m X-Gm-Gg: ASbGnctvT9Pdc92kdDGlI6AwmOdzYgchtdsSGJjs7E6D/SZzgeDAM0du1m0/O00LNTr iw1F5sVfZYP1WLQZpru72kRci/CWzAnsiOnoegi9De3111itFEXAVS9FdCqPy7/h7GuMKIQG/RJ OEr/Y47GvaV/bo/LlPD0EAOadS/gTTgKA/g+WYdo5yEcozgRoUrFpA95LVc2cPrkEVKmitvbOTQ WIsu3HMicA/hi44zl9QrzmvSABZy0uuxmhwPwcERg== X-Google-Smtp-Source: AGHT+IGt9vkrBZ/Ak4L9iSy1bzUOAsxd0nTEkDBM5PG0ewy7e8GGJ1wm7KR3acTI9YNAY+hU50PhP/WNMWgoNbdRFOE= X-Received: by 2002:a05:6e02:1b06:b0:3e2:985b:4796 with SMTP id e9e14a558f8ab-3e2985b4972mr19750865ab.1.1752845585986; Fri, 18 Jul 2025 06:33:05 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Greg Sabino Mullane Date: Fri, 18 Jul 2025 09:32:29 -0400 X-Gm-Features: Ac12FXxo9lm5EBZdYZkEDZ-mWDW7IXcWNSkzp0k9bqNzhfjaU2HM0vgBqhNGDk8 Message-ID: Subject: Re: PgBouncer Prepared Statement ERROR To: KK CHN Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000007fbe7d063a342af5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007fbe7d063a342af5 Content-Type: text/plain; charset="UTF-8" Make sure max_prepared_statements is set to nonzero in your config. See: https://www.crunchydata.com/blog/prepared-statements-in-transaction-mode-for-pgbouncer Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support --0000000000007fbe7d063a342af5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Make sure =C2=A0max_prepared_statements is set to nonzero = in your config. See:

https://www.crunchydata= .com/blog/prepared-statements-in-transaction-mode-for-pgbouncer

=
Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Softwa= re Products & Tech Support
--0000000000007fbe7d063a342af5--