Skip to content

FATAL: could not locate required checkpoint record #253

@calvin2020

Description

@calvin2020

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions