© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
ImmichI
Immich•9mo ago•
8 replies
Mundelo

Migrating Immich database to Pikapods instance

I have an existing Immich instance hosted in a Docker container. I've been trying to move its contents into a Pikapods hosted Immich instance.

Pikapods exposes the PostgreSQL database of each instance through AdminerEvo, and the file system through an SFTP server.

I've been trying to import the database dump produced by Immich into the PostgreSQL database but I've been getting errors that prevent it from executing fully. Most of these are permission related.

Error in query (7): ERROR: must be member of role "postgres"

Error in query (7): ERROR: permission denied to create extension "vectors"
HINT: Must be superuser to create this extension.

Error in query (7): ERROR: syntax error at or near "\"
LINE 1: \connect immich
Error in query (7): ERROR: must be member of role "postgres"

Error in query (7): ERROR: permission denied to create extension "vectors"
HINT: Must be superuser to create this extension.

Error in query (7): ERROR: syntax error at or near "\"
LINE 1: \connect immich


I've ensured that both instances are updated to the latest version of Immich (v1.134.0).

DB_SKIP_MIGRATIONS was also set to true before first run on the Pikapods instance, as advised in the documentation. I can verify the database is empty after setting this variable.

After restarting the instance importing the database, and setting DB_SKIP_MIGRATIONS back to false, the log shows the following and the instance fails to run:

[Nest] 526  - 06/07/2025, 11:01:16 AM    WARN [Api:DatabaseRepository] Migration "1744910873969-InitialMigration" failed

[Nest] 526  - 06/07/2025, 11:01:16 AM   ERROR [Api:DatabaseRepository] Kysely migrations failed: PostgresError: type "assets_status_enum" already exists
[Nest] 526  - 06/07/2025, 11:01:16 AM    WARN [Api:DatabaseRepository] Migration "1744910873969-InitialMigration" failed

[Nest] 526  - 06/07/2025, 11:01:16 AM   ERROR [Api:DatabaseRepository] Kysely migrations failed: PostgresError: type "assets_status_enum" already exists


Pikapods official support is fairly minimal, so any support from someone who has previously imported an existing Immich instance into their service would be much appreciated. Thanks in advance!
ImmichJoin
A place to hang out, get support, discuss Immich, get announcements about releases and anything else going on.
36,590Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Migrating Immich to a new instance with a different database
ImmichIImmich / help-desk-support
8mo ago
migrating immich instance onto a different server.
ImmichIImmich / help-desk-support
6mo ago
Migrating to a new instance
ImmichIImmich / help-desk-support
15mo ago
Migrating Immich Instancr
ImmichIImmich / help-desk-support
7mo ago