Re: Replication sequence

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: Paolo Saudin <paolosaudin(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Replication sequence
Date: 2021-02-16 12:38:08
Message-ID: 20210216133808.5d4a15c0@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mutuku Ndeti 2021-02-16 13:55:47 PostgreSQL Replication
Previous Message Paolo Saudin 2021-02-16 12:10:54 Re: Replication sequence