Hey all, I was working on backup/restore and I was wondering:
Can attachments actually be reproduced from information of the database? A medical report should only be some kind of visualization of existing data I think but I'm not sure if this is true for all types of attachments.
And is there a functionality to check if e.g. there are indexes but files are missing?
I integrated Barman into the Ansible repo for PostgreSQL backups which allows to get a Recovery Point Object (RPO) of zero if synchronization is enabled between PostgreSQL server and backup server - so no data loss at all. However the data folder is backed up using Restic e.g. every 5 minutes and we were discussing in our university if it's worse to have inconsistencies or not to have RPO=0 at database level. What do you think?
Best Gerald
