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.
>
>
>
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 |