migrate immich backup to different server

[taisau]

I'd like to restore the immich database to a non-cloudron server. The Immich backup/restore instructions
say to do this:

gunzip < "/path/to/backup/dump.sql.gz"
| sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g"
| docker exec -i immich_postgres psql --username=postgres # Restore Backup
docker compose up -d # Start remainder of Immich apps

Can I use Cloudron's "postgresqldump "backup to do this? It does not appear to be a gzip file. "gzip: stdin: not in gzip format".

Or is there an easier way to restore the database on a non-cloudron server?

[nebulon]

The postgresdump is just not zipped for Cloudron, so do not use gunzip but use the plaintext file directly.

[joseph]

Also see: https://docs.cloudron.io/guides/import-postgresql/ and https://docs.cloudron.io/guides/connect-postgresql/