Re: Determine if postgresql cluster running is primary or not

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: Raul Kaubi <raulkaubi(at)gmail(dot)com>
Cc: Thomas Kellerer <shammat(at)gmx(dot)net>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Determine if postgresql cluster running is primary or not
Date: 2020-11-20 10:04:03
Message-ID: C9C805DE-FDBD-4EF2-A3FC-DE87381212D8@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Raul,

> On 20. Nov, 2020, at 10:41, Raul Kaubi <raulkaubi(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roger Wolff 2020-11-20 10:20:43 Recovering old installation.
Previous Message Paul Förster 2020-11-20 10:02:20 Re: Determine if postgresql cluster running is primary or not