safe-backup
safe-backup copied to clipboard
No concurrent backups possible
Both skripts worked very good till now for our backups. Last night we had the problem that a second client started a backup before the backup from the first client was finished. Postgresql should be able to handle two non-exclusive backups, but the scripts can not handle this situation correctly.
My proposal would be to add a optional parameter to both scripts to add an additional information, from which client the backup was started and the scripts can so differ between the different clients. For the table backup also an additional text field would be necessary.
That is not an unreasonable request. However, my goal when I wrote this was a replacement for the pre- and post-backup scripts you could use with exclusive backup, and exclusive backup doesn't allow concurrent backups be definition. I don't intend to work on that enhancement myself, as I consider it somewhat outside the scope of these scripts and would make them more complicated. But I'd consider a pull request if somebody else wants to do the legwork.