| From: | Raul Kaubi <raulkaubi(at)gmail(dot)com> |
|---|---|
| To: | Paul Förster <paul(dot)foerster(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:45:10 |
| Message-ID: | CAO_+3-C=SNTMgDNhyNof54EBENHc+moej9Ky4Wdf1sYrmWKoeQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hmm, ok.
But how is this possible..?
when b.sender>0 and c.receiver>0 then
> 'Primary+Replica'
Raul
Kontakt Paul Förster (<paul(dot)foerster(at)gmail(dot)com>) kirjutas kuupäeval R, 20.
november 2020 kell 12:04:
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Förster | 2020-11-20 10:54:35 | Re: Determine if postgresql cluster running is primary or not |
| Previous Message | Roger Wolff | 2020-11-20 10:44:25 | Re: Recovering old installation. |