Re: Replication sequence

From: Paolo Saudin <paolosaudin(at)gmail(dot)com>
To: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Replication sequence
Date: 2021-02-16 14:28:48
Message-ID: CADtZQgnra2OUtMR9Q=mT_3obtySvbF63741s8Rk6P=ce+s7ypA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you!

Il giorno mar 16 feb 2021 alle ore 13:38 Jehan-Guillaume de Rorthais <
jgdr(at)dalibo(dot)com> ha scritto:

> On Tue, 16 Feb 2021 13:10:54 +0100
> Paolo Saudin <paolosaudin(at)gmail(dot)com> wrote:
>
> > Il giorno mar 16 feb 2021 alle ore 10:51 Jehan-Guillaume de Rorthais <
> > [...]
> >
> > [...]
> > [...]
> > [...]
> > [...]
> > [...]
> > [...]
> > [...]
> >
> > Thank you very much!
> > So in case the primary server crashes, and the backup one gets live, it
> > will eventually have different sequences.
>
> No. You will just have a gap in the sequence, on both side.
>
> And if you decided to promote your standby to production, you'll have to
> resync
> the old primary anyway.
>
> > I suppose there is no way to
> > avoid this, isnt'it?
>
> You can't avoid gap.
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raul Giucich 2021-02-16 14:28:54 Re: PostgreSQL Replication
Previous Message Mutuku Ndeti 2021-02-16 13:55:47 PostgreSQL Replication