Summary
Error
This error LOG: invalid secondary checkpoint record0PANIC: could not locate a valid checkpoint record can be found under the pg_log file .
Windows:
drive:\ProgramData\HP\HP BTO Software\shared\nnm\databases\Postgres\pg_log
Unix:
/var/opt/OV/shared/nnm/databases/Postgres/pg_log
Cause
This error may occur if the database was not started correctly.
Fix
The solution for this issue is executing the following steps:
1-ovstop -v
2-Run
Windows:
"\Program Files (x86)\HP\HP BTO Software\nonOV\Postgres\bin\pg_resetxlog" -f "\ProgramData\HP\HP BTO Software\shared\nnm\databases\Postgres"
Unix:
/var/opt/nonov/Postgres/bin/pg_resetxlog -f /var/opt/OV/shared/nnm/databases/Postgres
3-ovstart -v