WithHold Cursor issue post migration to Azure - Mailing list pgsql-admin

From Rakesh Nashine
Subject WithHold Cursor issue post migration to Azure
Date
Msg-id CAP_RtMTHO2E4jt0uQH+5M-4L3bEBa3io1VngYQD2zpULssuVLQ@mail.gmail.com
Whole thread Raw
List pgsql-admin
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)

postgresql12-odbc-17.00.0002-1PGDG.rhel9.x86_64

postgresql12-libs-12.22-1PGDG.rhel9.x86_64

 

DBHOSTDB005

 

postgresql12-libs-12.3-1PGDG.rhel7.x86_64

psql (PostgreSQL) 12.3

HOSTAPP002            (Re-hosted)

postgresql12-odbc-12.01.0000-1PGDG.rhel7.x86_64

postgresql12-libs-12.3-5PGDG.rhel7.x86_64

 

DBHOSTDB001

 

postgresql12-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

pgsql-admin by date:

Previous
From: Tzuriel Kahlon
Date:
Subject: Re: OS upgrade
Next
From: Raj
Date:
Subject: Re: OS upgrade