Hmm, ok.
But how is this possible..?
when b.sender>0 and c.receiver>0 then
'Primary+Replica'
Raul
Kontakt Paul Förster (<paul.foerster@xxxxxxxxx>) kirjutas kuupäeval R, 20. november 2020 kell 12:04:
Hi Raul,
> On 20. Nov, 2020, at 10:41, Raul Kaubi <raulkaubi@xxxxxxxxx> 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
