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 1tb3Ke-007ZWp-6e for pgsql-odbc@arkaria.postgresql.org; Thu, 23 Jan 2025 19:57:40 +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 1tb3Kd-003jbc-5s for pgsql-odbc@arkaria.postgresql.org; Thu, 23 Jan 2025 19:57:39 +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 1tb3Kc-003jbU-VE for pgsql-odbc@lists.postgresql.org; Thu, 23 Jan 2025 19:57:38 +0000 Received: from pgintl.fastcrypt.com ([149.56.129.164]) by makus.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tb3Ka-0019F0-1l for pgsql-odbc@postgresql.org; Thu, 23 Jan 2025 19:57:38 +0000 Received: from mail-ej1-f45.google.com (mail-ej1-f45.google.com [209.85.218.45]) by pgintl.fastcrypt.com (Postfix) with ESMTPSA id A4AEC2029C for ; Thu, 23 Jan 2025 14:57:35 -0500 (EST) Received: by mail-ej1-f45.google.com with SMTP id a640c23a62f3a-ab2aea81cd8so246908066b.2 for ; Thu, 23 Jan 2025 11:57:35 -0800 (PST) X-Gm-Message-State: AOJu0YwfzoM23nJ8ZLgyxh2E/7CfrsnQHK5hzF7k3VE1k4bY4vR3wa3h j+IRFA8XfcXnUr3JQV7DEva3fpzZc4iKVJ+XjJ4bLqbhBJYjpePxAtpg8jyGHSM1ySMyeE9MqXS Mz0hC+Bh/064wwMAyB9JBsZTTkhk= X-Google-Smtp-Source: AGHT+IHlV8+BQHA1kQ2QmQXZmRcs3sqbcRxJM6oWv9KyKmBk3jCYX4CSrqclCgDEOGwN8tXFofTqBXstfwVQYMzCxhE= X-Received: by 2002:a17:907:d1b:b0:aae:fd36:f511 with SMTP id a640c23a62f3a-ab38b3cce8cmr2492863166b.47.1737662254668; Thu, 23 Jan 2025 11:57:34 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Dave Cramer Date: Thu, 23 Jan 2025 14:57:18 -0500 X-Gmail-Original-Message-ID: X-Gm-Features: AWEUYZllbe9t_JJ4by3oENmRiDNae615UnUnbq9aiO0pXjWxsqbNSdtnKfT6xKk Message-ID: Subject: Re: Setting a Master/Slave connection with Postgres ODBC Driver To: CRUZ ARGUETA Cesar Miguel Cc: "pgsql-odbc@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000006deb3f062c6505a4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006deb3f062c6505a4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello, Not that I am aware of. It may be possible to do so using something like HA Proxy. Dave Cramer www.postgres.rocks On Thu, 23 Jan 2025 at 14:36, CRUZ ARGUETA Cesar Miguel wrote: > Hello team, > > > > We are using Postgres ODBC driver and need to configure a master/slave > connection to point always to the read/write node. It=E2=80=99s possible = to > configure that with the postgres odbc driver? > > > > Thanks and best regards. > > Interno > Este mensaje contiene informacion confidencial destinada para ser > 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 > 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 > 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 > parties. Any unauthorised disclosure, use or dissemination, either > whole or partial, is prohibited. If you are not the intended > recipient of the message, please notify the sender as soon as > possible. > --0000000000006deb3f062c6505a4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

Not that I am aware o= f.
It may be possible to do so using something like HA Proxy.

Dave Cramer
www.postgres.rock= s


On Thu, 23 Jan 2025 at 1= 4:36, CRUZ ARGUETA Cesar Miguel <ce= sar.cruz@axa.es> wrote:

Hello team,

=C2=A0

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=E2=80=99s possible to configure that with the postgres o= dbc driver?

=C2=A0

Thanks and best regards.=


Interno

Este mensaje contiene informacion confidencial destinada para ser
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
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
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
parties. Any unauthorised disclosure, use or dissemination, either
whole or partial, is prohibited. If you are not the intended
recipient of the message, please notify the sender as soon as
possible.
--0000000000006deb3f062c6505a4--