pg_rman icon indicating copy to clipboard operation
pg_rman copied to clipboard

FATAL: could not locate required checkpoint record

Open calvin2020 opened this issue 2 years ago • 1 comments

Hi:

My PostgreSQL version is 16,and I installed pg_rman-1.3.15-1.pg15 in my server,backup is ok to use pg_rman and retore is also OK,but when I startup my postgreSQL 16,I got below errors: 2023-11-09 11:28:57.916 CST [310402] FATAL: could not locate required checkpoint record 2023-11-09 11:28:57.916 CST [310402] HINT: If you are restoring from a backup, touch "/data/pgsql/16/data/recovery.signal" and add required recovery options. If you are not restoring from a backup, try removing the file "/data/pgsql/16/data/backup_label". Be careful: removing "/data/pgsql/16/data/backup_label" will result in a corrupt cluster if restoring from a backup. 2023-11-09 11:28:57.917 CST [310398] LOG: startup process (PID 310402) exited with exit code 1 2023-11-09 11:28:57.917 CST [310398] LOG: aborting startup due to startup process failure 2023-11-09 11:28:57.920 CST [310398] LOG: database system is shut down

I added configuration as below to /data/pgsql/16/data/recovery.signal according to /data/pgsql/16/data/pg_rman_recovery.conf

restore_command = 'cp /data/pgsql/16/data/pg_archive/%f %p' recovery_target_timeline = '5'

Does this mean pg_rman-1.3.15-1.pg15 is incompatible with PostgreSQL 16? look forward to your reply thanks

calvin2020 avatar Nov 09 '23 03:11 calvin2020

Hi, @calvin2020

Thank you for your asking. As you see, pg_rman is not compatible to postgresql 16. We will try to release a new version as soon as possible.

zwyan0 avatar Nov 09 '23 04:11 zwyan0