#"/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist checksum

1 messages · Page 1 of 1 (latest)

half scaffold
#

I recently made had the displeasure of transfering my NAS OS to the latest version, which included rebuilding Docker Containers. As most of my data is persistant, I belived this should be fine....

However, upon rebuilding Immich, everything seems to be working apart from the "immich_postgres" container which reports as unhealthy and "/var/run/postgresql:5432 - accepting connections psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist checksum"

Looking into the console, I unfortunatly do not belive the location this leads to was persistant, and might have been lost with rebuilding the containers, depsite all other data being the same. What are my options? And is there any way to fix it?

Thanks, sincerely.

hearty swallowBOT
fast pendant
#

You can check for the existing backup and restore it

half scaffold
#

Does it auto create backups?

fast pendant
#

If your immich version was recent enough, yes

half scaffold
#

Sorry for the slightly dumb question

#

It should be

fast pendant
#

it's in UPLOAD_LOCATION/backups

half scaffold
#

Here let me try as we speak

#

So the only way is to rebuild the compose?

#

Having persistant locations for most of my things, it should be fine I think right?

#

Also, resotring a older backup, what happens to images and thumbnails etc made after the backup?

#

I am looking at the backup location, and there is only 4 of them, the oldest one being when I started this 4 days ago

#

Not sure where the other backup files went

#

I should mention the website and apps all worked fine, all my old photos and stuff were there, just this error in the container status

#

I belive even the earliest database backup I have would have this issue.

#

If theres anyway to fix the database error inplace, that I guess would be ideal, but otherwise I assume I'd be looking at rebuilding the database or likewise right?

crude hill
#

The concern isn’t the error, you said the volume was non persistent and all data is lost

#

The health check error you post wouldn’t stop immich from working. However if you want more info you need to post a lot more. All the logs, details on the deployment etc

half scaffold
half scaffold
#

Womp womp. Wrong chat lol