Re: How to determine whether I'm running on a standby?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to determine whether I'm running on a standby?
Date: 2022-02-10 19:56:42
Message-ID: CAKFQuwaJvK1vz3D25tSemLrb_hAS3ZegCORJAG02r3WtADTxTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 10, 2022 at 12:54 PM Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
wrote:

> The procedure works fine on the primary but reports a bunch of errors on
> the read-only standbys.
>
A standby is in perpetual recovery mode. There is a function that returns a
boolean true if you are in recovery.

https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-RECOVERY-CONTROL

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2022-02-10 21:13:33 Re: Can we go beyond the standard to make Postgres radically better?
Previous Message Mladen Gogala 2022-02-10 19:54:05 How to determine whether I'm running on a standby?