Backup failure
❓Question☑️Ready
I've been using Immich for about a year without any issues, until recently. I'm on version 2.5.6 and my backups are failing with this error in the logs
[Nest] 8 - 03/15/2026, 2:01:34 PM LOG [Microservices:DatabaseBackupService] Database Backup Starting. Database Version: 14
/usr/lib/postgresql/14/bin/pg_dump exited (1)
[Nest] 8 - 03/15/2026, 2:01:38 PM ERROR [Microservices:DatabaseBackupService] Database Backup Failure: Error: /usr/lib/postgresql/14/bin/pg_dump non-zero exit code (1)
pg_dump: error: Dumping the contents of table "asset" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR: timestamp out of range
pg_dump: error: The command was: COPY public.asset (id, "deviceAssetId", "ownerId", "deviceId", type, "originalPath", "fileCreatedAt", "fileModifiedAt", "isFavorite", duration, "encodedVideoPath", checksum, "livePhotoVideoId", "updatedAt", "createdAt", "originalFileName", thumbhash, "isOffline", "libraryId", "isExternal", "deletedAt", "localDateTime", "stackId", "duplicateId", status, "updateId", visibility, width, height, "isEdited") TO stdout;
The backup fails right after kicking off the backup. I have verified that I do not have any images with out of date range EXIF data (at least not that I can find). I have also tried restoring my DB from a backup before this started happening. When I try to restore the restore fails right away with the same error. I'm pretty new to using Docker and never uses Postgres before so I'm not even sure where to start with this. Any help would be appreciated. Thanks
[Nest] 8 - 03/15/2026, 2:01:34 PM LOG [Microservices:DatabaseBackupService] Database Backup Starting. Database Version: 14
/usr/lib/postgresql/14/bin/pg_dump exited (1)
[Nest] 8 - 03/15/2026, 2:01:38 PM ERROR [Microservices:DatabaseBackupService] Database Backup Failure: Error: /usr/lib/postgresql/14/bin/pg_dump non-zero exit code (1)
pg_dump: error: Dumping the contents of table "asset" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR: timestamp out of range
pg_dump: error: The command was: COPY public.asset (id, "deviceAssetId", "ownerId", "deviceId", type, "originalPath", "fileCreatedAt", "fileModifiedAt", "isFavorite", duration, "encodedVideoPath", checksum, "livePhotoVideoId", "updatedAt", "createdAt", "originalFileName", thumbhash, "isOffline", "libraryId", "isExternal", "deletedAt", "localDateTime", "stackId", "duplicateId", status, "updateId", visibility, width, height, "isEdited") TO stdout;
The backup fails right after kicking off the backup. I have verified that I do not have any images with out of date range EXIF data (at least not that I can find). I have also tried restoring my DB from a backup before this started happening. When I try to restore the restore fails right away with the same error. I'm pretty new to using Docker and never uses Postgres before so I'm not even sure where to start with this. Any help would be appreciated. Thanks
