Re: Can there ever be out of sequence WAL files?
От | Julien Rouhaud |
---|---|
Тема | Re: Can there ever be out of sequence WAL files? |
Дата | |
Msg-id | 20220112021811.5sthbk3rx4m5egvt@jrouhaud обсуждение исходный текст |
Ответ на | Re: Can there ever be out of sequence WAL files? (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>) |
Ответы |
Re: Can there ever be out of sequence WAL files?
|
Список | pgsql-hackers |
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, 000000010000020C000000A2, 000000010000020C000000A3, > > 000000010000020C000000A5 and so on, missing 000000010000020C000000A4. > > Manual/Accidental deletion of the WAL files can happes, but are there > > any other extreme situations (like recycling, removing old WAL files > > etc.) caused by the postgres server leading to missing WAL files? By definition there shouldn't be such situation, as it would otherwise be a (critical) bug. > > What happens when postgres server finds missing WAL file during > > crash/standby recovery? The recovery should fail.
В списке pgsql-hackers по дате отправления: