Nuclos backup: database, BLOB, pg_dump, pgAdmin, Navicat, restore, document attachments. |
Language: Deutsch · English
Back up the database and application – save BLOBs correctly, recommended methods and testing the restore.
On this page |
A backup should go without saying – both the database and the application (which holds document attachments, among others) must be backed up.
It is crucial that BLOBs are saved correctly. BLOBs contain, among others:
If BLOBs are not saved correctly, a restore is not possible – the backup is then useless. |
The database front-end Navicat Premium saves BLOBs incorrectly on Linux (bug) – such backups are unusable. The macOS version works correctly. |
Test every backup method with an actual restore – only then is it guaranteed that the backup can be applied correctly.