Re: Clean shutdown and warm standby

Heikki Linnakangas wrote:
>
> No, no crash is involved. Just a normal server shutdown and start:
>
> 1. Server shutdown is initiated
> 2. A shutdown checkpoint is recorded at XLOG point 1234, redo ptr is 
> also 1234.
> 3. A XLOG_SWITCH record is written at 1235, right after the checkpoint 
> record.
> 4. The last round of archiving is done. The partial WAL file 
> containing the checkpoint and XLOG_SWITCH record is archived.
> 5. Postmaster exits.
>
> 6. Postmaster is started again. Since the system was shut down 
> cleanly, no WAL recovery is done. The WAL insert pointer is 
> initialized to right after the redo pointer, location 1235, which is 
> also the location of the XLOG_SWITCH record.
> 7. The next WAL record written will be written at 1235, overwriting 
> the XLOG_SWITCH record.
> 8. When the WAL file fills up, the system will try to archive the same 
> WAL file again, this time with additional WAL records that after the 
> checkpoint record. 

So to get this down to a solution, it appears to be correct to execute 
the RequestXLogSwitch right before CreateCheckPoint?


Regards,
Andreas