MIME-Version: 1.0
From: YoungUk Song <pidaoh@g.skku.edu>
Date: Sun, 8 Dec 2024 21:45:34 +0900
Message-ID: 
 <CAK9ZnjNECXcXshq6OVzx8ryf0i7KNrp9TErhNkL0ga0c=K-GFA@mail.gmail.com>
Subject: Best Practices for Checking PostgreSQL Server Mode with Multiple
 Connections
To: psycopg@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000006613860628c1a0b7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAK9ZnjNECXcXshq6OVzx8ryf0i7KNrp9TErhNkL0ga0c%3DK-GFA%40mail.gmail.com>
Precedence: bulk

--0000000000006613860628c1a0b7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Team,

I=E2=80=99m currently implementing a solution to establish more than 500 da=
tabase
connections to a single server to verify whether the PostgreSQL server is
in read-only or read-write mode.

My current approach is to create individual database connections and
execute the pg_is_in_recovery() function for each connection to determine
the mode.

I=E2=80=99m curious if there are any best practices or more efficient metho=
ds to
achieve this.

Additionally, I=E2=80=99m not very familiar with Psycopg, so I would greatl=
y
appreciate any advice or suggestions on areas that might need improvement.

Looking forward to your insights!

--0000000000006613860628c1a0b7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><p>Hi Team,</p><p>I=E2=80=99m currently implementing a sol=
ution to establish more than 500 database connections to a single server to=
 verify whether the PostgreSQL server is in read-only or read-write mode.</=
p><p>My current approach is to create individual database connections and e=
xecute the <code>pg_is_in_recovery()</code> function for each connection to=
 determine the mode.</p><p>I=E2=80=99m curious if there are any best practi=
ces or more efficient methods to achieve this.</p><p>Additionally, I=E2=80=
=99m not very familiar with Psycopg, so I would greatly appreciate any advi=
ce or suggestions on areas that might need improvement.</p><p>Looking forwa=
rd to your insights!</p></div>

--0000000000006613860628c1a0b7--