Online backup & restore issue

Problem:
Backup using online backup is working.
When trying to restore the backup in new server which has exact copy of foreman installation as in backup server is not working.There is an issue on postgresql global objects.(attached screenshot below)
Expected outcome:
Restore complete successfully.
Foreman and Proxy versions:
Foreman 3.5 and Katello 4.7
Distribution and version:
Rocky Linux release 8.7 (Green Obsidian)
Other relevant data:
Status:

This is fixed in foreman_maintain 1.2.7+ which we didn’t backport to the 3.5 branch yet (but will soon).

So if I try to skip postgresql global object by using whitelist then the following fails,

Do I need to whitelist set of upcomming steps or what is the solution to complete the restore successfully?

You need to have the postgres user be able to read the files.

I could swear there was a check for that…

You mean I need to change postgres user password or is there particular command to make the user read the file?

No, the user postgres needs to be able to read /var/foreman-online-backup/…/*.dump files.

Right now, it can’t for some reason.

So you need to check the file permissions of that file and the folders above it.

Still the issue exists.

and what about /var, /var/foreman-online-backup, and /var/foreman-online-backup/katello-backup-2023-03-23-01-06-31?

/var/foreman-online-backup/katello-backup-2023-03-23-01-06-31 doesn’t seem to be readable by non-root?

Yes its working now after changing file permissions.