From: CRUZ ARGUETA Cesar Miguel <cesar.cruz@axa.es>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: Setting a Master/Slave connection with Postgres ODBC Driver
Thread-Topic: Setting a Master/Slave connection with Postgres ODBC Driver
Thread-Index: AdtsKj89B/sYo1PvRqexGLefU32Myg==
Date: Tue, 21 Jan 2025 17:31:37 +0000
Message-ID: 
 <DB9PR04MB93058EBE699582247DAD1BFCECE62@DB9PR04MB9305.eurprd04.prod.outlook.com>
Accept-Language: es-ES, en-US
Content-Language: es-ES
msip_labels: 
 MSIP_Label_432d5f8a-12aa-48f4-ac09-593b02e41a00_ActionId=660b4054-89d0-447d-88e4-f3db663ea7f4;MSIP_Label_432d5f8a-12aa-48f4-ac09-593b02e41a00_ContentBits=0;MSIP_Label_432d5f8a-12aa-48f4-ac09-593b02e41a00_Enabled=true;MSIP_Label_432d5f8a-12aa-48f4-ac09-593b02e41a00_Method=Standard;MSIP_Label_432d5f8a-12aa-48f4-ac09-593b02e41a00_Name=ES_INTERNAL;MSIP_Label_432d5f8a-12aa-48f4-ac09-593b02e41a00_SetDate=2025-01-21T17:29:20Z;MSIP_Label_432d5f8a-12aa-48f4-ac09-593b02e41a00_SiteId=396b38cc-aa65-492b-bb0e-3d94ed25a97b;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: DB9PR04MB9305:EE_|DBBPR04MB7804:EE_
x-ms-office365-filtering-correlation-id: 8f3278b5-19f1-499c-8618-08dd3a417549
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|366016|1800799024|376014|38070700018|8096899003;
x-microsoft-antispam-message-info: 
 =?us-ascii?Q?SavI0Ea+dU2dpetRvNOu62/WNap0wE+y5R2brr+uU2Di2AkJPq12ag2xfJSL?=
 =?us-ascii?Q?5IzazL0GpKq+gZkiVhrilV6757SHWaLyU1RGsRhNNFlZRVlT9GgkHoLdKkCX?=
 =?us-ascii?Q?NILgG7QQvc0uhI5UzVoKfel2HPEjHIvdntuKfLR0NZBfDNO3TmVzpFRY0apA?=
 =?us-ascii?Q?D4aRbs/GRWrW+ppyqgig0mA2W0sCvAk+MrVhfwr5s7C+sJtUvMQrJpnNc8NN?=
 =?us-ascii?Q?kfxZzgeGn/DSJElQ/H/MQAiFk/Gl17bTCGZxzDEpGnSyPjmglz3qG4Tf14pj?=
 =?us-ascii?Q?fZEoISowBBCR8f9rL3Chfb/QTMrxk9uW4+GnffqCPOKqm0FrQrWNkz5x7EUi?=
 =?us-ascii?Q?vOWxELmSvh7VUYTq8cJm0UhRj+vXYBENhKJ61XeXWjz+kX4UhqpnFPjKc00u?=
 =?us-ascii?Q?Dferep8wC6bOUqz0nPZDHwf31p8eIEbH6/hwim6J28adPJrJfuLtIHvh4YPh?=
 =?us-ascii?Q?UgKIhh0HvS2t9ZbxOJ9hCLQO1rxl22N/cTSHO7OlPllDxngIXpB7GfH6OvX6?=
 =?us-ascii?Q?9EWi7EfZ8SS/C2QWX98fXzFZjVqL32mRal1bWgyjljpassYO3bB1l8PcQe7q?=
 =?us-ascii?Q?5qpolMExD/TEM2KAyI8/uFJVUTVN8yk0ft1F93XA18hLjAh8DD6TjT+EDF4t?=
 =?us-ascii?Q?pHwW3WO/xfg03HziWHFpHOxY4jw2tLkU0nfdn5kAlqwYQyDaNFjNLP6FMg+4?=
 =?us-ascii?Q?h9vBgSOvD1mUIbH9Kvf418syyw/QDx+38i4cN+Fk13TfAeHGAKmO4N3Q30O2?=
 =?us-ascii?Q?ALNiRi4HIRuPncaHQhVtvYnyQC4D9+rkHdniTqT0OJOfQbaQOH7un9dcVoTp?=
 =?us-ascii?Q?tO0J/jKIQY3hnfPqZLvojhRL3jhZGIdTk5tald9MKoWsjAeSSYZ2gPEtMOsM?=
 =?us-ascii?Q?J81Qwm+ijYCEmHyIHpGfvz1TFHOFwl1ZwC3vpBZ3MGBqOuHEwmIpXcYwsp5e?=
 =?us-ascii?Q?W0+VU9XeOPIOCaLJWL7RSBg/b2LuD8TWZqYQkw9ZrOp+syq0QNwd3k0AG/lr?=
 =?us-ascii?Q?6Z2KS5tOgudX91o6w8eVD6ODp+iXQmJfppOCGXYG01Rkw1uHxmet9e0ukyZq?=
 =?us-ascii?Q?qSo6d7Ao0KEtiEMg8G+S1tYLbZk/pYKwyp9bAbwGqLQhcFLox0VMDS8qa0aK?=
 =?us-ascii?Q?deT+kaVIwlvuZgeWZpPcKge+LKh5fDawd+ZA7ZpcvJQgUC1A96Mr4vIY3l+K?=
 =?us-ascii?Q?xgnCtfaOCMqZXxc0GV1BatuCs2x+3YXiiNTdyewV6juYTkPADxAr6iLEpZzk?=
 =?us-ascii?Q?LZzq4/DI+CGuW8YLzEjqjLJVhqhMWD3KV2XATzogsuqGJe5YbAeZJLvBfPey?=
 =?us-ascii?Q?nKFFncwfSdNIX9ib+RPEb5HNpRp0fQrvqsE4byMR6/MN2kfCgBvnp7EoZWcI?=
 =?us-ascii?Q?1sZKSbN9lBpLTn0aPqCaBCPExQOIZVeZUp40plaFtuEYpNv1N5Y9jT2dO3gS?=
 =?us-ascii?Q?HmQ3u8Y4asRrP+2QouTCayDo8a+ns1kF?=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DB9PR04MB9305.eurprd04.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(38070700018)(8096899003);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?YIiuDsX1FZwE0s3zUscScIObj+NNQN+vE5Ya9JKDP7cqa8VcSkfvjrcqNF6G?=
 =?us-ascii?Q?fmtQFp8/9zinFjXTksxZg5ECZkxTQ9y6efEfeCiRxs5tGuK9gAD0vDNdmK3h?=
 =?us-ascii?Q?cGGF7VLWUlW0zElVz2HsfpHzvPMpxZwazoSJbNRHl6WIerSnnVSZ6zMbjy7x?=
 =?us-ascii?Q?gYeo1Ph+46n/0YwIiAII1df1ULaSuT+eSKkvsx3y9ZeyjOI6KBoQpB3NYSBl?=
 =?us-ascii?Q?fixW2p0Re9/180ufVDaM+xH5eYYMIkBptwJeQNPO/L0a4AAcVcl8s42T4ZPy?=
 =?us-ascii?Q?XrPtqUHnH1qCwVpUwu1KwSU1roRCibPWwAkbbRNPziVLMd5WFnUwJCbrcR34?=
 =?us-ascii?Q?yPU0wBWGmFwVWTFEzzui1NlwFaR/SDP9lsQTnzZCt9Bj7zQ1NfjXEvUY5tNf?=
 =?us-ascii?Q?6X6suhyukKh96Zjynng5YwVLNaSXcXepyoScpPoXH70v34TJ0DwYKRc9HOc0?=
 =?us-ascii?Q?zSteLm36d3Pb0rKgna3LLgVNV7+68w5Z6U3aT/3vT4csu3G3qCc+23+ko6xs?=
 =?us-ascii?Q?kNOcQNkDr37491JQ2z1KRx4/EB5zhFVtsEbkEyuEjcBMjMrfyvqBOZzrW11E?=
 =?us-ascii?Q?fJqhEDCEwkEkLV7a4gb8ekFdF4/1Sbts8s1bKPpYJbtcHqbLdeZacwsLfo7k?=
 =?us-ascii?Q?ycylyyVmLR4cvlmd7enAX3ku9hNTQNyqrtHrtHOZ1mI+eGQ0aCezMLJ7QPfE?=
 =?us-ascii?Q?eihUijSQtZa7wgxQlXSG8wIlkk2PHuyqjNg6e0Y/TOgGcbhyIW3m/IEbF6kL?=
 =?us-ascii?Q?JOf2qHcH1H5UgaNAbxQ96mBks+OwF7dtwmZS4KVUmhhrsUpFVNQqRHtkfzrS?=
 =?us-ascii?Q?9HnXbt5KPEggB2XISMeF02imO9JK3sYjUoru0QpFdonjT3S87VRtNM1dlqRE?=
 =?us-ascii?Q?brnrIF0ZO/qCV5YRrtqKdEILZ/PI7c3G8VmI8GXD0ZGy4/Pr7W/vMTM4Cwzo?=
 =?us-ascii?Q?Hrkj0HRCfxIDg5x8xkIwYVGq7nfNfBzVAx322SYZwQ9BVBWs7Y3xctNrs/BS?=
 =?us-ascii?Q?yj8M+ddZUPJFlzQGL4HeG8bcKQyjvUZoSWdHPqdbQ3TiabcOKSLv+mLjAE0P?=
 =?us-ascii?Q?c7gh5UT3gnoyxVEKCy2WLNTRE8IlDoD0J8nxwr588r30UPjFRUh7T+uEXrLw?=
 =?us-ascii?Q?piPkJxT+7O0zl8N+eZf0Svi9FaFFZhVXbpfV2DZ1f/+Dp1O9GALw7SEdVPeG?=
 =?us-ascii?Q?L7hRACVan0/r3d90vg4m+1pQK0AK4Sd9gvFEaeaWxhpRr/sEJ2lopAQeHDzb?=
 =?us-ascii?Q?Iiw21sQxgYIH4NK7oaZaVH3yB55S6+NFJTyN+cDRC5Ry+eOAe3NQyctvNfFo?=
 =?us-ascii?Q?36FUFQ3BVfm1y9vUhvzb+qiYxrn+U+zLSGHsMa4X7dma9P9fr59PinGeI6v8?=
 =?us-ascii?Q?El9FwhxoKQMB6b+2GyG6HylvOJQNC3ToqX2XG/qkgSsN+eS+FwysN6K7eiGK?=
 =?us-ascii?Q?Ce1a6nxrYsqjBro5otwPJl5FfoW6+FTURnfHJKaRSKR8DD2oQxgC+GsuNAyY?=
 =?us-ascii?Q?07qIynsCduPWImnMY4DWrrRwhOOGvlM4H6JbClawj14O9dJa+FpRxEe1z0xN?=
 =?us-ascii?Q?ZHGhphWu/E1SZJbZMkU=3D?=
Content-Type: multipart/alternative;
	boundary="_000_DB9PR04MB93058EBE699582247DAD1BFCECE62DB9PR04MB9305eurp_"
MIME-Version: 1.0
X-OriginatorOrg: axa.es
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DB9PR04MB9305.eurprd04.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 8f3278b5-19f1-499c-8618-08dd3a417549
X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Jan 2025 17:31:37.0903
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 396b38cc-aa65-492b-bb0e-3d94ed25a97b
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 3sM6xUoyxEzdk7PioMmHUg051OHUwK54Fh3t/xjSbHMfaKxOsJ3By8fAzzdOt56kjTi4u6jEFpldxL3feqhEzQ==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DBBPR04MB7804
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0
 spamscore=0 mlxlogscore=544
 malwarescore=0 phishscore=0 suspectscore=0 mlxscore=0 bulkscore=0
 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.19.0-2411120000 definitions=main-2501210140
X-Proofpoint-ORIG-GUID: 4f9AGIdiQQrL_qXuRpGS6UtPr81u13XT
X-Proofpoint-GUID: 4f9AGIdiQQrL_qXuRpGS6UtPr81u13XT
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1057,Hydra:6.0.680,FMLib:17.12.68.34
 definitions=2025-01-21_07,2025-01-21_03,2024-11-22_01
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 clxscore=1011
 phishscore=0 bulkscore=0
 priorityscore=1501 spamscore=0 mlxlogscore=502 mlxscore=0 adultscore=0
 impostorscore=0 suspectscore=0 lowpriorityscore=0 malwarescore=0
 classifier=spam adjust=-50 reason=mlx scancount=1 engine=8.19.0-2411120000
 definitions=main-2501210140
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/DB9PR04MB93058EBE699582247DAD1BFCECE62%40DB9PR04MB9305.eurprd04.prod.outlook.com>
Precedence: bulk

--_000_DB9PR04MB93058EBE699582247DAD1BFCECE62DB9PR04MB9305eurp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello team,

We are using Postgres ODBC driver and need to configure a master/slave conn=
ection to point always to the read/write node. It's possible to configure t=
hat with the postgres odbc driver?

Thanks and best regards.


Interno

Este mensaje contiene  informacion  confidencial destinada  para ser=20
leida exclusivamente por el destinatario. Su contenido no constituye
un compromiso  para AXA salvo ratificacion escrita por ambas partes.
Queda  prohibida la  reproduccion,  publicacion, divulgacion,  total =20
o parcial del mensaje asi como el uso  no autorizados por el emisor.
En caso de recibir el mensaje por error, se ruega su comunicacion al=20
remitente lo antes posible.


This message contains confidential information for the exclusive use
of the recipient. Its contents do not constitute a commitment by AXA
except  where  provided  for in  a  signed  agreement  between  both=20
parties.  Any unauthorised disclosure,  use or dissemination, either
whole  or  partial,  is  prohibited.  If you  are  not  the intended=20
recipient  of  the  message,  please  notify  the  sender as soon as
possible.

--_000_DB9PR04MB93058EBE699582247DAD1BFCECE62DB9PR04MB9305eurp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ligatures:standardcontextual;
	mso-fareast-language:EN-US;}
span.EstiloCorreo17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"ES" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:bre=
ak-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello team,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">We are using Postgres ODBC driv=
er and need to configure a master/slave connection to point always to the r=
ead/write node. It&#8217;s possible to configure that with the postgres odb=
c driver?<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Thanks and best regards.<o:p></=
o:p></span></p>
</div>
<br>
<p style=3D"font-family:Calibri;font-size:10pt;color:#000000;margin:15pt;fo=
nt-style:normal;font-weight:normal;text-decoration:none;" align=3D"Center">
Interno<br>
</p>

<DIV>
Este mensaje contiene  informacion  confidencial destinada  para ser <BR>
leida exclusivamente por el destinatario. Su contenido no constituye<BR>
un compromiso  para AXA salvo ratificacion escrita por ambas partes.<BR>
Queda  prohibida la  reproduccion,  publicacion, divulgacion,  total  <BR>
o parcial del mensaje asi como el uso  no autorizados por el emisor.<BR>
En caso de recibir el mensaje por error, se ruega su comunicacion al <BR>
remitente lo antes posible.<BR>
<BR>
<BR>
This message contains confidential information for the exclusive use<BR>
of the recipient. Its contents do not constitute a commitment by AXA<BR>
except  where  provided  for in  a  signed  agreement  between  both <BR>
parties.  Any unauthorised disclosure,  use or dissemination, either<BR>
whole  or  partial,  is  prohibited.  If you  are  not  the intended <BR>
recipient  of  the  message,  please  notify  the  sender as soon as<BR>
possible.<BR>
</DIV></body>
</html>

--_000_DB9PR04MB93058EBE699582247DAD1BFCECE62DB9PR04MB9305eurp_--