search

ossc-db / pg_rman

Backup and restore management tool for PostgreSQL
http://ossc-db.github.io/pg_rman/index.html
Other
476 stars 77 forks source link

FATAL: could not locate required checkpoint record #253

Open calvin2020 opened 1 year ago

calvin2020 commented 1 year ago

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

zwyan0 commented 1 year ago

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.