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
THUMB_LOCATION=/Volumes/Work/Photos/immich/thumbs
ENCODED_VIDEO_LOCATION=/Volumes/Work/Photos/immich/encoded-video
PROFILE_LOCATION=/Volumes/Work/Photos/immich/profile
Please use only the characters
DB_PASSWORD=xxx
DB_USERNAME=postgres
DB_DATABASE_NAME=immich
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/immichTHUMB_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=./postgresTo 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=releaseConnection 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=xxxA-Za-z0-9The values below this line do not need to be changed
###################################################################################DB_USERNAME=postgres
DB_DATABASE_NAME=immich
