At Thu, 16 Jun 2022 19:46:25 -0700, Harinath Kanchu <hkan...@apple.com> wrote in > > Hello, > > If postgres fail when it is starting as standby due to WAL file corruption, > can we get the status through any exit code or by parsing pg_control file ? > > I can see the “XX001” code is emitted in logs but parsing logs doesn’t seem > to be a good option. Please suggest.
I'm not sure exactly what is what you want to achieve here, but there is a negative evidence for the reliability of detecting WAL corruption failure without searching server logs. [64923:startup] [XX000] 2022-06-17 13:30:52.493 JST PANIC: incorrect resource manager data checksum in record at 0/3000060 At least in this case, there's no trace of a server-stop due to WAL corruption left behind other than in server log. regards. -- Kyotaro Horiguchi NTT Open Source Software Center
