Re: Can there ever be out of sequence WAL files?

2022-01-16 Thread Michael Paquier
On Wed, Jan 12, 2022 at 12:23:00PM +0800, Julien Rouhaud wrote: > On Wed, Jan 12, 2022 at 01:10:25PM +0900, Michael Paquier wrote: >> xlog.c can be a good read to check the assumptions WAL replay relies >> on, with things like CheckRecoveryConsistency() or >> reachedConsistency. > > That should

Re: Can there ever be out of sequence WAL files?

2022-01-11 Thread Julien Rouhaud
On Wed, Jan 12, 2022 at 01:10:25PM +0900, Michael Paquier wrote: > > xlog.c can be a good read to check the assumptions WAL replay relies > on, with things like CheckRecoveryConsistency() or > reachedConsistency. That should only stand for a WAL expected to be missing right? For something

Re: Can there ever be out of sequence WAL files?

2022-01-11 Thread Michael Paquier
On Wed, Jan 12, 2022 at 10:18:11AM +0800, Julien Rouhaud wrote: > On Wed, Jan 12, 2022 at 07:19:48AM +0530, Bharath Rupireddy wrote: >>> Can the postgres server ever have/generate out of sequence WAL files? >>> For instance, 0001020C00A2, 0001020C00A3, >>>

Re: Can there ever be out of sequence WAL files?

2022-01-11 Thread Julien Rouhaud
On Wed, Jan 12, 2022 at 07:19:48AM +0530, Bharath Rupireddy wrote: > > > > Can the postgres server ever have/generate out of sequence WAL files? > > For instance, 0001020C00A2, 0001020C00A3, > > 0001020C00A5 and so on, missing 0001020C00A4. > >

Re: Can there ever be out of sequence WAL files?

2022-01-11 Thread Bharath Rupireddy
On Tue, Dec 28, 2021 at 7:45 AM Bharath Rupireddy wrote: > > Hi, > > Can the postgres server ever have/generate out of sequence WAL files? > For instance, 0001020C00A2, 0001020C00A3, > 0001020C00A5 and so on, missing 0001020C00A4. >

Can there ever be out of sequence WAL files?

2021-12-27 Thread Bharath Rupireddy
Hi, Can the postgres server ever have/generate out of sequence WAL files? For instance, 0001020C00A2, 0001020C00A3, 0001020C00A5 and so on, missing 0001020C00A4. Manual/Accidental deletion of the WAL files can happes, but are there any other extreme