Re: Determine if postgresql cluster running is primary or not

Ok, Thanks!

Raul

Kontakt Paul Förster (<paul(dot)foerster(at)gmail(dot)com>) kirjutas kuupäeval R, 20.
november 2020 kell 12:54:

> Hi Raul,
>
> > On 20. Nov, 2020, at 11:45, Raul Kaubi <raulkaubi(at)gmail(dot)com> wrote:
> >
> > Hmm, ok.
> >
> > But how is this possible..?
> >
> > when b.sender>0 and c.receiver>0 then
> > 'Primary+Replica'
> >
> > Raul
>
> this happens for example if you have a primary a and replica b running as
> a normal cluster (we use Patroni for automatic failover) and then add
> another replica c to the existing replica b, effectively replicating: a =>
> b => c In this case, b would be the replica of a, but also be the primary
> for c.
>
> It's called cascading replication.
>
> Cheers,
> Paul