At Thu, 16 Jun 2022 19:46:25 -0700, Harinath Kanchu <hkanchu@xxxxxxxxx> 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
