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.96) (envelope-from ) id 1vKwKx-00E6PO-10 for pgsql-odbc@arkaria.postgresql.org; Mon, 17 Nov 2025 10:19:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vKwKu-00DSZh-2V for pgsql-odbc@arkaria.postgresql.org; Mon, 17 Nov 2025 10:19:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vKe7y-00AuNm-0L for pgsql-odbc@lists.postgresql.org; Sun, 16 Nov 2025 14:53:18 +0000 Received: from esa16.hc834-32.eu.iphmx.com ([194.165.193.198]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vKe7t-0083C5-16 for pgsql-odbc@postgresql.org; Sun, 16 Nov 2025 14:53:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amdocs.com; i=@amdocs.com; q=dns/txt; s=mail01; t=1763304793; x=1794840793; h=from:to:subject:date:message-id; bh=/7y28mYIgzIUxttIxI9SQIVqMi045KSMLHqP3gucisk=; b=d5ScpbPhjnIp4mWT5evNbh0Y8HyCKXEV9M1okC7aDOidtzbwLbYy9YRC jW8aHpOmC+TY8Vi0CODpoZBnpRNO1jzh0mDmij9PgW2xwGwp+hbJ5Np/O st1hKW9rTgvT8Yh0TTKiuh7jJv6cPmTAsl646zrhNFZjNkJRe0WBixoZh c=; X-CSE-ConnectionGUID: 1n3Se9rZT9OC4vE16nZ81Q== X-CSE-MsgGUID: f6MndoMGQYu41XcxFT7snA== X-Amp-Result: SKIPPED(no attachment in message) Content-Type: multipart/mixed; boundary="===============1635838391447407907==" MIME-Version: 1.0 Received: from unknown (HELO mta1a.mail.zscalertwo.net) ([136.226.142.110]) by ob1.hc834-32.eu.iphmx.com with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 16 Nov 2025 14:53:09 +0000 Received: from am0pr83cu005.outbound.protection.outlook.com ([52.101.69.35]) by mta1a.mail.zscalertwo.net ([136.226.142.95]) with ESMTPS id 6919E55308C00000; Sun, 16 Nov 2025 06:53:07 -0800 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=hE850uuYnBNsz6p/s1drVwZd1Yoo1/w5R3MUAcGrS1M54r+rKzcL5FgSJLPPNX47fT40rj9Z6FCmPBmLU79TZn8FmIKsu1W4Fi30i7gz9N8iTe2ctMIPEvzmbvGIdXRXJhpwwPaPrDp5QuUYwRzS8le5QGZPK7CDF4iYO25tMhcN2sjzldSdRkfOqK+bIkqfhERqf2JfUrOQOlHHBez5NHWlm7QNemjmsPW3ddLSxvCQCk06+bGtoBtfxXQd+hN7jZSU7PySuiHbVJPkmLXAv2BcDLbOvGtokDL2xQftVgXOIkJoUooFjcdcH6O5vFBC1A5UEyMyD0VfJxl2NW9uGg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=wDCMS3wiAXJfzMviCLE7ulROHxhYabjphxAkmS6Gqws=; b=GRNUdJyX6NP2QfUgJgTp2cJm++4mXXaoWjcaNpox45iAnl+s3dKoO5bxBoQCsq3hsammRFs+NlUQhofzqzHLb5gjZVuIPIBUrGQxtQzXVQ0VsVYS9QXidnXkTQ4wByXTTsRtCxDNHkvSrPu5YZZs7pzUy1OwcNPlXs/0s04x9BB4blHr69lz2dSpXuSzlsUFONDk6BXxsKDt5IX800ebGoHqYMEF6UgGGcGvtIr7YPTTlJvbxNES5H/oZCfeE0dTpSRJEL3JWmqbUFqz3ghaDKq6R1lYqfbp3oj16tJ/dpd4OsGHH1NBjfaJRmwXdw45mzI2LrF/woi0+FvTGz7hRQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=amdocs.com; dmarc=pass action=none header.from=amdocs.com; dkim=pass header.d=amdocs.com; arc=none Received: from GV2PR06MB10155.eurprd06.prod.outlook.com (2603:10a6:150:2d5::8) by GV1PR06MB8355.eurprd06.prod.outlook.com (2603:10a6:150:1e::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9320.20; Sun, 16 Nov 2025 14:53:02 +0000 Received: from GV2PR06MB10155.eurprd06.prod.outlook.com ([fe80::eee4:3e4a:ae0d:c18]) by GV2PR06MB10155.eurprd06.prod.outlook.com ([fe80::eee4:3e4a:ae0d:c18%4]) with mapi id 15.20.9320.018; Sun, 16 Nov 2025 14:53:02 +0000 From: Neeta Ghadge To: "pgsql-odbc@postgresql.org" Subject: Guidance on avoiding session pinning with psqlODBC and RDS Proxy Thread-Topic: Guidance on avoiding session pinning with psqlODBC and RDS Proxy Thread-Index: AdxXCGCgLia7S1nNRlSpXdCFb9+apw== Date: Sun, 16 Nov 2025 14:53:02 +0000 Message-ID: Accept-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=amdocs.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: GV2PR06MB10155:EE_|GV1PR06MB8355:EE_ x-ms-office365-filtering-correlation-id: 38397f2c-2412-4f1d-649f-08de251fd7cb x-amddisc: IN x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|38070700021|8096899003; x-microsoft-antispam-message-info: =?us-ascii?Q?VG1Nn69sSMBdi0Iyvcm8DAECiJS8Kmwor70rUP1w1R0lb14Swbju2a6pPlxO?= =?us-ascii?Q?E/whcCmO7G1yJh35Q+XJEnyScKqneu8EQ8SCI2yWQYfkT5iaiXLQZHR9A5Kl?= =?us-ascii?Q?N4g8zVKMMCvMLOSREM1XtJ6ftQVk8IQzEBusyN+9KXx7z3/wLNaP2mVtoQAA?= =?us-ascii?Q?xwjNau6qU7QyLG71kqYO0qjYtvqegcn/bLZphHgl4DneSyy5rm7JrYR/8aoh?= =?us-ascii?Q?EBTTRdhRdYRLM4MmkqEfSGDGQWv7gSSo4GLvqh17T/nHP4a6gpeP1PSfXrPI?= =?us-ascii?Q?0gLPeCBWFI9U7stzqpjjjzsQz2j/3o+gzVWR4BuOwajLm6YDKLdp3I+/Kzih?= =?us-ascii?Q?78UyR+oy84ca1+wB9aIuOFBvWaJd2Ao8bHSG3BlY2Ock/WCtU++emIj/esbc?= =?us-ascii?Q?/54TNO9LUlQjfdcZ6Ut7kTVht+LzAHnz4c/GTnTy6tgOJ/xsP+WYNAQ3bRUe?= =?us-ascii?Q?zozOEQk9Rkcma/4u/8XxdQYebi7VHLsvcpzjwxevYeCTTEyTpoBqjnWwA4Xr?= =?us-ascii?Q?RjxBMWxZcRN6ojNmkATzoBg0kpnM5YCZasPi3LfsxGUi23R4e2PiDHDyeD1p?= =?us-ascii?Q?FYGlc5crzplK+Ajs2gHcCehyKaidIFGKUoKwffExZwBA5ANAdYljOXzVIRvR?= =?us-ascii?Q?ZGhDK8xfJVChi2GnekuPUjEUTSbfLp5AFwihBKoNOsU3lN8QIA8wLlrNFYYH?= =?us-ascii?Q?TLN0KipTVp/t9CxlHlhkvRP+zhWo3xiY45D/d0BufsFtP0yHiwEi5UGYgcju?= =?us-ascii?Q?KyRAsQRxPbWJVwf1dkq2np409SdMcm/mHNSGPtKAvsmxbBWayu1/ryQM92Gl?= =?us-ascii?Q?BCsj4Wv4vVoRULMe3dYKBT+eN0LQ5wJ0FR879EQAsxnt1cD2lANHCjIEXe6Y?= =?us-ascii?Q?X8LSuE6/TOR3yFH0uDx27p6rgpc8Li/dPCfnzwfN49oZCuKeyZXMjIo8p+Pe?= =?us-ascii?Q?YaZSEadbEaZf7HgWmN0LPd3VQW4WNhJz187SAnRPaKqLVNGM0YxBDSBuWXNF?= =?us-ascii?Q?Ulm2Lh/Uc1ypeGcA9Eb76kkrdHrwtwAAneN6Yh1sjpcbTm0Ab3CT53rhSPFK?= =?us-ascii?Q?jnyBONiBzIMLT0hIzTS/vp6HOyGHNMj9yIpsvPcxAFWI8bNfcJjd61MR3XA/?= =?us-ascii?Q?RLh+P9Z4h+hjvKOPHg9hyYHz4PoA59/anNZcrzbdPsQinckCEWbm7Zjzh7KA?= =?us-ascii?Q?R0PFD6dUBCorKFtmbgcoEpinK2o1Vb/cjmUhlF5/8KS7F8KpU7Aq8mjcIpVR?= =?us-ascii?Q?SwRZRArI3nruVt0laKpUGjIs3n0lR3XxXf5zXlnl9dWBJT0VDY7r8l6dVpnx?= =?us-ascii?Q?MN3CXfMkRO9EeizlQrpXlCqwa1iwoA+le6fDjGj6K5ZRhzdTIxvHWCyZaGiQ?= =?us-ascii?Q?yYX4be5znrLM0usEGsxaFLK/NQMhGtZxc3K8KjDU+X2zkB7sYEhHUeTg+eya?= =?us-ascii?Q?mv4JPjm/VqhR0bKbs3YKcPPucp9coT6+LzuKsrGGSxsMvtLwKIjJruEo6B3B?= =?us-ascii?Q?W6G2PyGjztEpgTRb+MRxOA3tSO67wcTM7WrA?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV2PR06MB10155.eurprd06.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(38070700021)(8096899003);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?EfobN4q0kFbj0u0xDLaQ4w/447bQq45ew/h8Y2s/EemNavTCsvMVmMWOGPGz?= =?us-ascii?Q?e7Nmy1xwf/VcAgt9QRoRWjLJhxS6brVgMn+Y3dE7yVia/XIGbtdsIHbRP2ln?= =?us-ascii?Q?ZyxJ52p+p/h2znsWXIz7jorZj3RMYatl67seWVaC1epPS3phj54CvWM0I68o?= =?us-ascii?Q?Y11WV6IOUCnfVlinmF85zx/lX+L/kM1QbTi33cUeVBXlAQgZD1C3UClQT3/+?= =?us-ascii?Q?PtC8MqCXQgT9Yr9qhRw/kzMgQFqGg1GRSV8WMmsx7B1Thv3pg4GESr57W+mf?= =?us-ascii?Q?nt990LrvcVd7bsYs3oTrkafS9IGpJFiTOYfwkvAqzbuDu7R8mtTPsvUEe8ie?= =?us-ascii?Q?ai9satDpjeOf2XrdkCajpkbhxRdo4IYGYBaZPLA0NJg/o7BAwuCLPb7f4fL0?= =?us-ascii?Q?fonLijOs7nJfp22R7oavE1UJTKNAgTT6lFTYAymj3jsnejyNKcwHR/gBgVCP?= =?us-ascii?Q?OZIa+gJYMfcHXgmjXGwze15CeqOuxunW3F9ZDtrs4XMY3gNw+1fhGjBWSYuY?= =?us-ascii?Q?J/qHnZm4ya4f51yexRlutBl5+4ng2eIuOfC5XpbTVacRFnITTWjSAjVX0xda?= =?us-ascii?Q?2fzLHYkjAe6UmGUCv+Xai8KK5lMWJLxGUCPiuPRF4GpR7rdL6EUmcuFTSaxZ?= =?us-ascii?Q?+a3+9NHnWZpF+ebGs6l9nonGFfxKTi180teKZV4uYscqheDGz4ztuGqWviPw?= =?us-ascii?Q?D3skV64fTj7EQklcSDt+8f28fRbR8gnlstJT6UvyJSJEMlipRfU+6YeeOZl5?= =?us-ascii?Q?YTyoDdhLnkLOgPeAGJ73swrA4Pqfzhd93SzziD2SqCu3TJ18IKzmUS9A2aYU?= =?us-ascii?Q?e6M61j7Zkrd0Su0uI2kuAfTvY0JRBQO/UPoieV8MC8uKgp18KIChPAz9Iy6l?= =?us-ascii?Q?YLME9T0akNr9Nq7zO8wWVgl1K+9OdVUB3tqBzAUhB2yWNghiC0LnW/4nZ6BO?= =?us-ascii?Q?pIE40nWEtkJtMdLhzG3mK/+09kjzrRmXeq+9tVfnU9AW4kNYV4vZrYT5RbE9?= =?us-ascii?Q?tu6E1bOSsxg/sqTJtRcLvbhOxbLVI1mTkpYXd3R8mt7IKIzNgXDcIY2uQIH+?= =?us-ascii?Q?rrZ/Ho0pB5+PSL6p4jqEGKY2yVwGNqqT2J5UuofaaCxUg1klOOqGpa/EKV4r?= =?us-ascii?Q?rXMdLfVrPFtABwCE44+A7bvnqSxYsu08QcqwR05ziqX3Qc9Yuv/Bipi0olwf?= =?us-ascii?Q?+ylAOK8BT4wyT2BZgqlIFGXzHwInvbUfXclAeGH+rjdr7eMyQiaXT6CGvxc/?= =?us-ascii?Q?oomhrikZ169GCl5zmK67YOoOWYrNXZc9u8jDy25rUybJvwa29rRrgFAUb7hX?= =?us-ascii?Q?fsykMnQOG+HSLrnJo7UublxFw0KwIHpReidtZu7EgxXKFtu/mPwnXntsXJLP?= =?us-ascii?Q?MOalhqzv6wvNWBS6VSuvm9eabE/6AEo8W6B9poP1/pPwVZIDYfzbdTE1MGfy?= =?us-ascii?Q?Ko67csgcBv2TBNPKnXNuLUCyizzgbVa5H01ctUcuZ1f+ngcv8n13Yk06dgEA?= =?us-ascii?Q?HxZC1zZ3ChQ56xbRwcGUMdBRPAYwXxk6ZO6iDx1cRr4J92VXLP/ytHag8H7l?= =?us-ascii?Q?XJW/7urCRN6pnk+aHS4=3D?= MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: yOHfDT216MLg1C04IdDnqKONKXMaL/RTEjvwF27d2zoxBRaaQNhrd1i1cK/cGJjt6sukFPRGLm/1YMXQRhbtK1QCGf9l5nZTovuejBszVc2QcV9nnj7DFBD0RvJ1GiX/KsZCBsFb0hnQyo4URCRSLaItRDCMXRS46RW3ez4ZfcyQ1lHlvpXKFka6h6f3b4pZ9uRDQZb6arQ8chnJwmOvblxucxn8eZ45X7FhW7+mZd5n2sw3OagPHA/L87Xfmk1yrxcQ5/xinzvGIUHd/dHd9/HRFLXCQQeOgWchIyhewLKBcTZ6YBeSp7Qp2sJP5bNs8OI/ehjbveqdWLNVQWJjkc03nTI01+NWFNLUsOznuIeNn9OTftqliweLRMIMsV5W73UvG6kPqAGnNAG6WXCMll6VBWpTPRMaa8Yu9HC/Q3DL6mUU9igGHdlNdXZ8grSwb7zubC7P0Awp7XrE287dG1Noud5n7ehMNl10AFSlJfNcHQlp894Fcw1dfELr9YVISwUwjyty8X4ETuG7lYMnUWcgW1NUImkTgXZK54OIND9AyKcUWdZ9+8slLdxcxQelDWFJwRGuv+gqAJ03diQbzizA9ndRXs/27DaKg4/zqmE8qoU8O2WRfQ7gl5hHshBp X-OriginatorOrg: amdocs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: GV2PR06MB10155.eurprd06.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 38397f2c-2412-4f1d-649f-08de251fd7cb X-MS-Exchange-CrossTenant-originalarrivaltime: 16 Nov 2025 14:53:02.5432 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: c8eca3ca-1276-46d5-9d9d-a0f2a028920f X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: UfGvuTcB+I+3lMcCEV2jKRa8nhZYJinnSuZZOcD21HC7JUCUY/PSoFw0xplzFSTumLCYZT7RyPTW5rUOfZ4bog== X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV1PR06MB8355 X-Zscaler-Block: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1635838391447407907== Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_GV2PR06MB1015502FA364CFD79E4F1412BFFC8AGV2PR06MB10155eu_" --_000_GV2PR06MB1015502FA364CFD79E4F1412BFFC8AGV2PR06MB10155eu_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, We are currently using PostgreSQL 16.5 with the ODBC driver (psqlodbcw.so v= ersion 17.00.0006) in an environment that relies on Amazon RDS Proxy. We have observed that the driver automatically issues the following SQL sta= tements at connection startup: SET DateStyle =3D 'ISO'; SET extra_float_digits =3D 2; SHOW transaction_isolation; While harmless in most cases, these queries cause AWS RDS Proxy to pin sess= ions, which reduces pooling efficiency. We can neutralize the SET commands = using RDS Proxy's InitQuery feature, but SHOW transaction_isolation still f= orces pinning. Could you please suggest recommended ways to handle this scenario when usin= g psqlODBC with RDS Proxy? Specifically, are there configuration options or= best practices to avoid or minimize session pinning while still maintainin= g ODBC compliance? Thank you for your guidance. Thanks and Regards, Neeta Ghadge --_000_GV2PR06MB1015502FA364CFD79E4F1412BFFC8AGV2PR06MB10155eu_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,
We are currently using PostgreSQL 16.5 with the ODBC driver (psqlodbcw.so v= ersion 17.00.0006) in an environment that relies on Amazon RDS Proxy.<= /o:p>

We have observed that the driver auto= matically issues the following SQL statements at connection startup:

SET DateStyle =3D 'ISO';

SET extra_float_digits =3D 2;=

SHOW transaction_isolation;

 

While harmless in most cases, thes= e queries cause AWS RDS Proxy to pin sessions, which reduces pooling effici= ency. We can neutralize the SET commands using RDS Proxy’s InitQuery feature, but SHOW transaction_isolation still = forces pinning.

 

Could you please suggest recommended = ways to handle this scenario when using psqlODBC with RDS Proxy? Specifical= ly, are there configuration options or best practices to avoid or minimize session pinning while still maintaining ODBC complian= ce?

 

Thank you for your guidance.

 

 =

Thanks and Regards,

Neeta Ghadge

 

--_000_GV2PR06MB1015502FA364CFD79E4F1412BFFC8AGV2PR06MB10155eu_-- --===============1635838391447407907== Content-Type: multipart/alternative; boundary="===============7673298168718896196==" MIME-Version: 1.0 Content-Disposition: inline --===============7673298168718896196== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable This message and the information contained herein is proprietary and confid= ential and subject to the Amdocs policy statement, you may review at https:= //www.amdocs.com/about/email-disclaimer Amdocs Development Centre India Private Limited having CIN: U72200PN2004PTC= 0188320 converted into Amdocs Development Centre India LLP (A limited liabi= lity partner=C2=ADship with LLP Identification Number: AAI-6901 effective 2= 8th Feb 2017) --===============7673298168718896196== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable

This message and the= information contained herein is proprietary and confidential and subject t= o the Amdocs policy statement, you may review at https://www.amdocs.com/about/email-disclaim= er

Amdocs Development C= entre India Private Limited having CIN: U72200PN2004PTC0188320 converted in= to Amdocs Development Centre India LLP (A limited liability partner=C2=ADsh= ip with LLP Identification Number: AAI-6901 effective 28th Feb 2017)

--===============7673298168718896196==-- --===============1635838391447407907==--