Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Best Practices for Checking PostgreSQL Server Mode with Multiple
 Connections
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: 
 <CAK9ZnjPFsPTd20HHjX8NhpiS9zTJTAde1p30BKx85BqSiM-MgQ@mail.gmail.com>
Date: Mon, 9 Dec 2024 06:14:30 -0800
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 psycopg@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <F9E69013-F05C-4095-A1BC-DA1B8F6B781A@thebuild.com>
References: 
 <CAK9ZnjNECXcXshq6OVzx8ryf0i7KNrp9TErhNkL0ga0c=K-GFA@mail.gmail.com>
 <5ed40ad0-5012-48fa-b5c0-61abf7713080@aklaver.com>
 <CAK9ZnjPvnXgZa28gpXWw0A2wkUBJnmm5dtk3sYJKkm9UgnND0Q@mail.gmail.com>
 <CAK9ZnjPFsPTd20HHjX8NhpiS9zTJTAde1p30BKx85BqSiM-MgQ@mail.gmail.com>
To: YoungUk Song <pidaoh@g.skku.edu>
Archived-At: 
 <https://www.postgresql.org/message-id/F9E69013-F05C-4095-A1BC-DA1B8F6B781A%40thebuild.com>
Precedence: bulk


> On Dec 9, 2024, at 06:04, YoungUk Song <pidaoh@g.skku.edu> wrote:
> Are there any best practices for efficiently handling this task across =
such a large number of servers?

Out of curiosity, shouldn't something in your infrastructure know this =
information already?  After all, something created all these servers.

That being said, you will need to open connections to the servers to =
determine if they are in recovery or not.  You might be able to do a =
small optimization in that, when you connect, you also query to see what =
servers are attached to that server as binary replicas: you can then =
remove them from the list of servers that need to be checked, since you =
know they are in recovery.  If you have cascaded binary replicas, =
however, this could end up creating more work than it solves.=