Backup does not respect the postgres port

[martabal]

The bug

As the title says.

immich/server/src/services/backup.service.ts

Line 88 in be2b76b

const databaseParams = isUrlConnection ? [config.url] : ['-U', config.username, '-h', config.host];

And if the service fails, an empty temp file is created immich-db-backup-1730941200145.sql.gz.tmp

The OS that Immich Server is running on

Unraid

Version of Immich Server

v1.120.0

Version of Immich Mobile App

v1.120.0

Platform with the issue

• Server
• Web
• Mobile

Your docker-compose.yml content

N/A

Your .env content

N/A

Reproduction steps

1. Use a different port the postgres db
2. Run the backup job
3. Should throw an error in the docker logs
   ...

Relevant log output

pg_dumpall: error: connection to server at "postgres_immich", port 5432 failed: FATAL:  password authentication failed for user "immich"

(I have a different postgres server running on port 5432)

Additional information

No response

[zackpollard]

Resolved by #13970

[bo0tzz]

Only if using a DB_URL, but not with DB_PORT right @zackpollard ?

[martabal]

Only if using a DB_URL, but not with DB_PORT right @zackpollard ?

Yeah, it does not fix that issue

[zackpollard]

Sorry, I somehow got those mixed up 😆