Seitenhistorie
| Auszug | ||
|---|---|---|
| ||
Nuclos backup: database, BLOB, pg_dump, pgAdmin, Navicat, restore, document attachments. |
Language: Deutsch · English
Backup
Back up the database and application – save BLOBs correctly, recommended methods and testing the restore.
| Status | ||||
|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
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
| Warnung | ||
|---|---|---|
| ||
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)
| Info | ||
|---|---|---|
| ||
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