Re: Determine if postgresql cluster running is primary or not - Mailing list pgsql-general

From David G. Johnston
Subject Re: Determine if postgresql cluster running is primary or not
Date
Msg-id CAKFQuwbWCe+sQhR+Xg9Rz3Eh-0kTYD3x4+Tx9paAFntcNKeRLA@mail.gmail.com
Whole thread Raw
In response to Re: Determine if postgresql cluster running is primary or not  (Paul Förster <paul.foerster@gmail.com>)
Responses Re: Determine if postgresql cluster running is primary or not  (Paul Förster <paul.foerster@gmail.com>)
List pgsql-general

On Friday, November 20, 2020, Paul Förster <paul.foerster@gmail.com> wrote:

> On 20. Nov, 2020, at 10:03, Thomas Kellerer <shammat@gmx.net> wrote:

>
>   select pg_is_in_recovery();

I usually don't recommend using pg_is_in_recovery() only because a database cluster can be in recovery for other reasons. This is why I always do the following:

Do any of those other reasons allow connections that could execute that function to exist?

David J.
 

pgsql-general by date:

Previous
From: Paul Förster
Date:
Subject: Re: Determine if postgresql cluster running is primary or not
Next
From: "Zwettler Markus (OIZ)"
Date:
Subject: AW: Linux package upgrade without dependency conflicts