Language: Deutsch · English
Backup
Back up the database and application – save BLOBs correctly, recommended methods and testing the restore.
HOW-TO ADMINISTRATOR UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X
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.
Database backup
It is crucial that BLOBs are saved correctly. BLOBs contain, among others:
- header for checking the database version (GZIP binary)
- image components
- state model layouts
BLOBs are critical
If BLOBs are not saved correctly, a restore is not possible – the backup is then useless.
Recommended methods (PostgreSQL)
- pg_dump via console/script (recommended, scriptable)
- backup via pgAdmin (GUI)
Beware Navicat/Linux
The database front-end Navicat Premium saves BLOBs incorrectly on Linux (bug) – such backups are unusable. The macOS version works correctly.
Test the restore
Test every backup method with an actual restore – only then is it guaranteed that the backup can be applied correctly.
Related pages
Überblick
Inhalte