mingyee Comments - Answer Overflow

$ docker exec -i immich_postgres psql --username=postgres immich-db-backup-1732932000009.sql
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432"
failed: FATAL:  database "immich-db-backup-1732932000009.sql" does not exist

$ docker exec -i immich_postgres psql --username=postgres immich-db-backup-1732932000009.sql
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432"
failed: FATAL:  database "immich-db-backup-1732932000009.sql" does not exist

39 replies

IImmich

•Created by mingyee on 12/14/2024 in #help-desk-support

Unable to connect to database

Is there a way for me to debug what’s going on?

39 replies

IImmich

•Created by mingyee on 12/14/2024 in #help-desk-support

Unable to connect to database

It didn’t, though, so I guess this was the failure point

39 replies

IImmich

•Created by mingyee on 12/14/2024 in #help-desk-support

Unable to connect to database

I’m running on Cygwin, so it does have gunzip

39 replies

IImmich

•Created by mingyee on 12/14/2024 in #help-desk-support

Unable to connect to database

(Obviously I put the actual correct path)

39 replies

IImmich

•Created by mingyee on 12/14/2024 in #help-desk-support

Unable to connect to database

gunzip /absolute/path/to/file.sql.gz |sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | docker exec -i immich_postgres psql --username=postgres

39 replies

IImmich

•Created by mingyee on 12/14/2024 in #help-desk-support

Unable to connect to database

I copied that line from the instructions, unless I copied it wrong 😅

39 replies

IImmich

•Created by mingyee on 12/14/2024 in #help-desk-support

Unable to connect to database

Yeah, on Windows

39 replies

IImmich