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