Hi Team,
I’m currently implementing a solution 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.
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’m curious if there are any best practices or more efficient methods to achieve this.
Additionally, I’m not very familiar with Psycopg, so I would greatly appreciate any advice or suggestions on areas that might need improvement.
Looking forward to your insights!