Sample Header Ad - 728x90

How to solve cp: cannot stat 00000002.history: No such file or directory/LOG: invalid primary checkpoint record during PITR?

0 votes
0 answers
436 views
I have tried to recover a database, using the Point-in-Time Recovery method, through the postgresql.conf file, setting the recovery_target_time parameter at a specific time in past, but I cannot start the cluster and recover the database, I am getting the following output in the log file: 2024-08-08 09:37:11.429 CEST LOG: database system was interrupted; last known up at 2024-07-13 21:12:24 CEST cp: cannot stat '/appl/pgsql/15/bkp/WAL/00000002.history': No such file or directory 2024-08-08 09:37:11.443 CEST LOG: starting point-in-time recovery to 2024-07-14 20:00:00+02 2024-08-08 09:37:11.443 CEST LOG: invalid primary checkpoint record 2024-08-08 09:37:11.443 CEST PANIC: could not locate a valid checkpoint record 2024-08-08 09:37:11.556 CEST LOG: startup process (PID 3492124) was terminated by signal 6: Aborted 2024-08-08 09:37:11.556 CEST LOG: aborting startup due to startup process failure 2024-08-08 09:37:11.558 CEST LOG: database system is shut down I have seen different questions similar to mine, but also different answers, so I am not sure what can be the problem. What I can imagine is that it must have something to do with the version of the database, which is the 15, I have seen some things related to backup have changed since this version has been released, but I am not sure. Has anyone had this issue before?
Asked by Diogo dos Santos (3 rep)
Aug 9, 2024, 01:28 PM
Last activity: Aug 10, 2024, 02:35 AM