pekflyer
IImmich
•Created by pekflyer on 1/14/2025 in #help-desk-support
Can no longer access to postgres after system upgrade
I finally had time to upgrade the immich to the latest version, however, I was unable to use it at all. I looked around on this board and it seems a postgres password issue. I did not touch my .env filie at all since everything is running locally.
I have tried to exec to the postgres from the Terminal (on mac) and ALTEREd the password but still no luck. I also tried to restore the instance from a backup and still the same error.
#.env
The location where your uploaded files are stored
UPLOAD_LOCATION=/Volumes/Work/Photos/immich
THUMB_LOCATION=/Volumes/Work/Photos/immich/thumbs
ENCODED_VIDEO_LOCATION=/Volumes/Work/Photos/immich/encoded-video
PROFILE_LOCATION=/Volumes/Work/Photos/immich/profile
The location where your database files are stored
DB_DATA_LOCATION=./postgres
To set a timezone, uncomment the next line and change Etc/UTC to a TZ identifier from this list: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones#List
TZ=Etc/UTC
The Immich version to use. You can pin this to a specific version like "v1.71.0"
IMMICH_VERSION=release
Connection secret for postgres. You should change it to a random password
Please use only the characters
A-Za-z0-9, without special characters or spaces
DB_PASSWORD=xxx
The values below this line do not need to be changed
###################################################################################
DB_USERNAME=postgres
DB_DATABASE_NAME=immich28 replies