Thank you!
Il giorno mar 16 feb 2021 alle ore 13:38 Jehan-Guillaume de Rorthais <
j...@dalibo.com> ha scritto:
> On Tue, 16 Feb 2021 13:10:54 +0100
> Paolo Saudin wrote:
>
> > Il giorno mar 16 feb 2021 alle ore 10:51 Jehan-Guillaume de Rorthais <
> > [...]
> >
> > [...]
> > [...]
> > [...]
>
On Tue, 16 Feb 2021 13:10:54 +0100
Paolo Saudin 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 bac
Il giorno mar 16 feb 2021 alle ore 10:51 Jehan-Guillaume de Rorthais <
j...@dalibo.com> ha scritto:
> On Mon, 15 Feb 2021 18:55:14 +0100
> Paolo Saudin wrote:
>
> > Hi all,
> > I have two servers, a primary and a secondary one with a streaming
> replica
> > setup.
> > Today I noticed that some se
On Mon, 15 Feb 2021 18:55:14 +0100
Paolo Saudin wrote:
> Hi all,
> I have two servers, a primary and a secondary one with a streaming replica
> setup.
> Today I noticed that some sequences are not lined-up, the replica ones are
> well ahead, while the records number is the same. How is it possibl
Il giorno lun 15 feb 2021 alle ore 20:40 Loles ha
scritto:
> One thing is the number of records in the table and another is the current
> value of the sequence.
>
> Execute:
>
> select max (field) from bobo.menu_pages;
>
> In both master and slave server.
>
> What give you back?
>
> "field" is th
One thing is the number of records in the table and another is the current
value of the sequence.
Execute:
select max (field) from bobo.menu_pages;
In both master and slave server.
What give you back?
"field" is the data that belongs to the sequence.
El lun., 15 feb. 2021 18:55, Paolo Saudi
Hi all,
I have two servers, a primary and a secondary one with a streaming replica
setup.
Today I noticed that some sequences are not lined-up, the replica ones are
well ahead, while the records number is the same. How is it possible?
Thanks,
Paolo
--
-- primary server
--
postgres@db-srv1:~$ psql
