Postgres Pro
Downloads
Home   >   mailing lists

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

From Paul Förster
Subject Re: Determine if postgresql cluster running is primary or not
Date
Msg-id C9C805DE-FDBD-4EF2-A3FC-DE87381212D8@gmail.com
Whole thread Raw
In response to Re: Determine if postgresql cluster running is primary or not  (Raul Kaubi <raulkaubi@gmail.com>)
Responses Re: Determine if postgresql cluster running is primary or not  (Raul Kaubi <raulkaubi@gmail.com>)
List pgsql-general
Tree view 
Hi Raul,

> On 20. Nov, 2020, at 10:41, Raul Kaubi <raulkaubi@gmail.com> wrote:
>
> Hi
>
> Thanks.
> Seems like 9.5 does not work.
>
> ERROR:  relation "pg_stat_wal_receiver" does not exist
> LINE 20:         from pg_stat_wal_receiver
>
> Any ide how to achieve this in 9.5 ?
>
> Raul

this query is tested to work on 10.x and newer, not 9.x. I don't have 9.x, so I can't say, sorry.

Cheers,
Paul

pgsql-general by date:

Previous
From: Paul Förster
Date:
Subject: Re: Determine if postgresql cluster running is primary or not
Next
From: Roger Wolff
Date:
Subject: Recovering old installation.