Hey, I’ve been using the official Nextcloud app on TrueNAS scale for a while now and it’s been through the docker migration already.
It’s currently still using postgres version 13 and I wanted to upgrade to version 17 recently. Unfortunately the database upgrade is failing with FATAL: role "postgres" does not exist.
I also noticed that the regular postgres container is complaining about this with postgres 13 before the upgrade:
2025-10-09 11:18:02.971175+00:002025-10-09 11:18:02.971 UTC [27] FATAL: role "postgres" does not exist
2025-10-09 11:18:33.061864+00:002025-10-09 11:18:33.061 UTC [43] FATAL: role "postgres" does not exist
2025-10-09 11:19:03.149462+00:002025-10-09 11:19:03.149 UTC [52] FATAL: role "postgres" does not exist
2025-10-09 11:19:33.230057+00:002025-10-09 11:19:33.229 UTC [60] FATAL: role "postgres" does not exist
2025-10-09 11:20:03.303558+00:002025-10-09 11:20:03.303 UTC [70] FATAL: role "postgres" does not exist
2025-10-09 11:20:33.406030+00:002025-10-09 11:20:33.405 UTC [78] FATAL: role "postgres" does not exist
2025-10-09 11:21:03.470520+00:002025-10-09 11:21:03.470 UTC [87] FATAL: role "postgres" does not exist
I assume something went wrong at some point and my database configuration doesn’t match my nextcloud configuration? Interestingly everything appears to be working normally, even with those errors in the log.
Any ideas would be greatly appreciated! Would love to upgrade to postgres 17 and resolve those fatals in the logs.