public inbox for [email protected]  
help / color / mirror / Atom feed
From: Rakesh Nashine <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: WithHold Cursor issue post migration to Azure
Date: Mon, 8 Dec 2025 21:32:28 +0530
Message-ID: <CAP_RtMTHO2E4jt0uQH+5M-4L3bEBa3io1VngYQD2zpULssuVLQ@mail.gmail.com> (raw)

We have recently migrated our postgreSQL DB to Azure with 12.3. version,
alongside we also migrated our application to newild build RHEL9 , but we
are facing withhold cursor issue and performance issue . Below are the
details .. I need expertise on how to resolve this ..

*Servers*

*ODBC Driver Version (psqlODBC)*

*PostgreSQL client libs version*

*PostgreSQL DB Verison*

*HOSTAPP007 (Azure)*

postgresql*12*-odbc-*17.00*.0002-1PGDG.rhel9.x86_64

postgresql*12*-libs-*12.22*-1PGDG.rhel9.x86_64



*DBHOSTDB005*



postgresql*12*-libs-*12.3*-1PGDG.rhel7.x86_64

psql (PostgreSQL) *12.3*

*HOSTAPP002            (Re-hosted)*

postgresql*12*-odbc-*12.01*.0000-1PGDG.rhel7.x86_64

postgresql*12*-libs-*12.3*-5PGDG.rhel7.x86_64



*DBHOSTDB001*



postgresql*12*-libs-*12.3*-1PGDG.rhel7.x86_64

psql (PostgreSQL) *12.3*

*Azure RHEL version:*

NAME="Red Hat Enterprise Linux"

VERSION="9.4 (Plow)"

ID="rhel"

ID_LIKE="fedora"

VERSION_ID="9.4"

PLATFORM_ID="platform:el9"

PRETTY_NAME="Red Hat Enterprise Linux 9.4 (Plow)"

ANSI_COLOR="0;31"

LOGO="fedora-logo-icon"

CPE_NAME="cpe:/o:redhat:enterprise_linux:9::baseos"




REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 9"

REDHAT_BUGZILLA_PRODUCT_VERSION=9.4

REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"

REDHAT_SUPPORT_PRODUCT_VERSION="9.4"


*On-prem RHEL Version:*



NAME="Red Hat Enterprise Linux Server"

VERSION="7.9 (Maipo)"

ID="rhel"

ID_LIKE="fedora"

VARIANT="Server"

VARIANT_ID="server"

VERSION_ID="7.9"

PRETTY_NAME="Red Hat Enterprise Linux Server 7.9 (Maipo)"

ANSI_COLOR="0;31"

CPE_NAME="cpe:/o:redhat:enterprise_linux:7.9:GA:server"




REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7"

REDHAT_BUGZILLA_PRODUCT_VERSION=7.9

REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"

REDHAT_SUPPORT_PRODUCT_VERSION="7.9"

-- 
Thanks & Regards
RN


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: WithHold Cursor issue post migration to Azure
  In-Reply-To: <CAP_RtMTHO2E4jt0uQH+5M-4L3bEBa3io1VngYQD2zpULssuVLQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox