I'm afraid I can't add much to the original report - it's too long ago, and I can't backtrack to try to repeat the exercise. The Noble upgrade installed PG16 and created the new cluster with a new port number above the normal, and all looked ok until I ran "sudo pg_upgradecluster 14 main", at which point I got the previously-reported errors. I tried to re-install the package, but that left me with the same problem. So I fixed it by manually changing the port numbers for the '14' cluster and then the new '16' cluster; then created myself as a new administrator, then created empty databases; and then remade the databases from the relevant datadumps. All then worked fine, so I dropped the old '14' cluster - which is why I can't backtrack to repeat the exercise. The critical point in the error is 'The program "postgres" is needed by pg_ctl but was not found in the same directory as "/usr/lib/postgresql/14/bin/pg_ctl"'. But in needing to get my database systems up and running again, I didn't check that, and wouldn't have been entirely sure what exactly to do anyway, given versioning problems. pg_upgradecluster should perhaps check such potential errors earlier, and be precise about what it needs. There is a 'postgres' in /usr/lib/postgresql/16/bin, but "14/bin" has been removed in the purge of '14', so I can't check it ... Sorry I can't be more helpful!
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2078494 Title: After upgrade to 24.04.1 LTS pg_upgradecluster fails To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-16/+bug/2078494/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
