Thanks for the additional logs. Looking at your attached pg_upgradecluster.OUT I see what you mean that it looks like it succeeded in porting the 'postgres' and 'template1' databases, but presumably you expected another database(s) to upgrade? Are those databases included in the 'main' cluster? If they're in a different cluster try running pg_upgradecluster on that one?
I don't think it is going to be necessary to run it as the 'postgres' user; it looks like from this script's output that it's changing user ok. However, it does take an optional 'newdatadir' argument that you may find useful for troubleshooting purposes. Btw, you probably already know this but pg_upgradecluster is a debian/ubuntu-specific proxy script to simplify the database upgrade process, and certainly we'd like to make it work properly. But if you're looking for a quicker fix you may want to look into upstream's (more manual) steps for upgrading databases. ** Changed in: postgresql-16 (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2081996 Title: After upgrade to 24.04.1 LTS pg_upgradecluster fails to upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-16/+bug/2081996/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs