Migrating from docker → proxmox LXC, restore failing - better way?
I recently moved my homelab into proxmox, which now has zfs via truenas, and my immich service moved from a separate device into an immich LXC (here). I started with process in
I have a full DB backup as described in the backup/restore docs.
The proxmox/immich setup has a different user/role setup, so I
- chopped the first ~40 lines where users/roles are dumped,
- updated all 'OWNER TO'
- and attempted to restore with a command like this:
I get a fair number of errors, of the sorts:
2 questions
Is this my best route? I'd be happy to use another method (e.g. immich-go) so long as I can maintain my albums and existing dedupe efforts
If so, am I missing the boat on postgres restore? Given a backup from a functioning immich, I wouldn't expect these kinds of errors...
Immich v1.135.3I have a full DB backup as described in the backup/restore docs.
The proxmox/immich setup has a different user/role setup, so I
- chopped the first ~40 lines where users/roles are dumped,
- updated all 'OWNER TO'
immich- and attempted to restore with a command like this:
cat ./immich-restore.sql | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | ./psql-immichI get a fair number of errors, of the sorts:
2 questions
Is this my best route? I'd be happy to use another method (e.g. immich-go) so long as I can maintain my albums and existing dedupe efforts
If so, am I missing the boat on postgres restore? Given a backup from a functioning immich, I wouldn't expect these kinds of errors...
