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=immichList of tz database time zones
This is a list of time zones from release 2024b of the tz database.
21 Replies
:wave: Hey @pekflyer,
Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker ps -a docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
- Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJAChecklist
I have...
1. :blue_square: verified I'm on the latest release(note that mobile app releases may take some time).
2. :blue_square: read applicable release notes.
3. :blue_square: reviewed the FAQs for known issues.
4. :blue_square: reviewed Github for known issues.
5. :blue_square: tried accessing Immich via local ip (without a custom reverse proxy).
6. :blue_square: uploaded the relevant information (see below).
7. :blue_square: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
Information
In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:
- Your docker-compose.yml and .env files.
- Logs from all the containers and their status (see above).
- All the troubleshooting steps you've tried so far.
- Any recent changes you've made to Immich or your system.
- Details about your system (both software/OS and hardware).
- Details about your storage (filesystems, type of disks, output of commands like
fdisk -l and df -h).
- The version of the Immich server, mobile app, and other relevant pieces.
- Any other information that you think might be relevant.
Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)
If this ticket can be closed you can use the /close command, and re-open it later if needed.GitHub
immich-app immich · Discussions
Explore the GitHub Discussions forum for immich-app immich. Discuss code, ask questions & collaborate with the developer community.
FAQ | Immich
User
GitHub
Issues · immich-app/immich
High performance self-hosted photo and video management solution. - Issues · immich-app/immich
How exactly did you try to ALTER the password?
I used this command from the support site: ALTER USER <DB_USERNAME> WITH ENCRYPTED PASSWORD 'newpasswordhere'; and then changed it in my env too
Did you rebuild the container after altering the password?
sorry what do you mean by rebuilding? runing docker compose up?
or pull?
Docker compose down
Docker compose up --build
Should I do that?
I am not sure if i did it or not, but i did follow the upgrade commands
After I ran the above commands I got the following logs:
You wouldn't happen to have that log in more than 1 line would you?
have you tried the default password?
docker inspect immich_postgres | grep PASSWORD
should yield whatever password the environment thinks you're usingLet me try Thanks Mraedis
I got the password that I applied to all .env files but the errors are still the same.
any chance you have the db dumps at UPLOAD_LOCATION/backups ?
my db dump file is on one drive, with the app and db, my upload location is on an external drive
Do you feel comfortable restoring to a date that still worked? https://immich.app/docs/administration/backup-and-restore/
I tried that, but I still cannot access to the database
I can try again
So you tried it and it still had the wrong password 🤔
That's bizarre to say the least
I am not 100% sure, but I think you don't even need the same password for a restore
hmm would it be something else? like why it is kept getting cannot connec to database error