Skip to content
View in the app

A better way to browse. Learn more.

Unraid

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Problems with Immich postgresql14 database

Featured Replies

Hi all, I've been happily running immich using community apps on my system for 2 years now. Aside from earlier breaking changes issues, it's been problem-free.

I had not logged into Immich for some time - but had updated Unraid a couple of times, and updated the dockers containers when shown there was an update available. When I logged in recently, it prompted to set up an admin user, then told me I had no photos. No obvious errors in the logs for immich, postgresql14, or redis. To troubleshoot, I noticed that the owner of my postgresql14 appdata was "UNKNOWN". Changing it in the Unraid GUI didn't help, as soon as I started the container it reverted back to UNKNOWN owner. I did not try restoring from backup, as I honestly don't know how long its been like this.

Googling solutions came up with a ranging fixes like manually editing docker templates etc, but nothing Unraid-specific.

I am currently running

Unraid 7.2.0

postgresql14 v 14.17

immich (latest update from Unraid docker tab.... could not query specific version from immich console, said postgresql14 error)

redis v 8.4.0

Any ideas where to start?

  • Community Expert
Brandon Martino - Personal Site
No image preview

Immich-on-Unraid-CA-Docker

Brandon Martino - Personal Site
  • Author

Thank you for that. Lots there. I'll work my way through it. Much appreciated.

  • Community Expert

alots happened in that stack.

v14 pgvetor was deprecated for future projects.
immich is maintain a off branch version of Postgres with vetochord.

you most likley need to set docker safe permissions.
chmod 777 -R *

chown nobody:users -R *

Are you using CA or compose?

  • Author
Just now, bmartino1 said:

alots happened in that stack.

v14 pgvetor was deprecated for future projects.
immich is maintain a off branch version of Postgres with vetochord.

you most likley need to set docker safe permissions.
chmod 777 -R *

chown nobody:users -R *

Are you using CA or compose?

I'm using CA. The postgresql branch looks to be a path.

Question though if I rebuild the stack using the guide earlier, how do I migrate my old database? Or do I need to start again?

  • Community Expert

You can restore you old dta if you have a backup and point the corect foldrs to immich. You are in charge of your own data and backup in this case. Is it possible to restore yes. the guide is more catored to fresh installs. but yes you can migrate your old datbase to the immich v16 tag.

Imich support forum as well: (As postgress has some things goin on...)
https://forums.unraid.net/topic/146106-immich-docker-self-hosted-google-photos-setup/page/8/#findComment-1590054
IF CA use Postgres v16 as the unraid docker tag for imagegenious immich server done't have things for pgv17 and 18 yet...

if compose, you can us the latest github tag v18 : https://bmartino1.weebly.com/immich-on-unraid-docker-compose-guide.html
*What teh immich maintainers want us to run...
some side updates to add things unraids uses such as icons and lables for the webUI.
https://forums.unraid.net/topic/193998-guide-immich-docker-setup-docker-compose/#findComment-1588925
--I have yet to fix the docker file on immich being disaplyed...

Postgress also thorwing soeme things in the way as

I've even added to the unriad CA for this migration. you just need to corectly specify the postgress data path and docker tag. atm I have the CA set for v18

  • Author
4 minutes ago, bmartino1 said:

You can restore you old dta if you have a backup and point the corect foldrs to immich. You are in charge of your own data and backup in this case. Is it possible to restore yes. the guide is more catored to fresh installs. but yes you can migrate your old datbase to the immich v16 tag.

Imich support forum as well: (As postgress has some things goin on...)
https://forums.unraid.net/topic/146106-immich-docker-self-hosted-google-photos-setup/page/8/#findComment-1590054
IF CA use Postgres v16 as the unraid docker tag for imagegenious immich server done't have things for pgv17 and 18 yet...

if compose, you can us the latest github tag v18 : https://bmartino1.weebly.com/immich-on-unraid-docker-compose-guide.html
*What teh immich maintainers want us to run...
some side updates to add things unraids uses such as icons and lables for the webUI.
https://forums.unraid.net/topic/193998-guide-immich-docker-setup-docker-compose/#findComment-1588925
--I have yet to fix the docker file on immich being disaplyed...

Postgress also thorwing soeme things in the way as

I've even added to the unriad CA for this migration. you just need to corectly specify the postgress data path and docker tag. atm I have the CA set for v18

Thank you that helps. Off I go.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.