Hi, Gerald On Thu, 7 Sep 2023 12:08:56 +0200 Gerald Wiese <wi...@gnuhealth.org> wrote:
> 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. > Attachments are stored at filesystem level, and a lin > And is there a functionality to check if e.g. there are indexes but > files are missing? Because the link of the attachment is stored at db level, we could traverse the links and match them with its correspondent file at FS. > > 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? > For point in time recovery, we would need both DB (archive logs enabled) and filesystem snapshots (to take care of attachments, configuration files, etc..) Hope this helps :) Bests Luis > Best > > Gerald > >
