Hello, Thanks for providing the requested information. Looking at the postgresql-16-main.log file, I see the following excerpt which caught my attention:
2024-09-21 15:51:05.322 BST [5823] mbm@simas FATAL: role "mbm" does not exist 2024-09-21 15:53:46.720 BST [5784] LOG: checkpoint starting: time 2024-09-21 15:53:59.679 BST [5784] LOG: checkpoint complete: wrote 128 buffers (0.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=12.572 s, sync=0.240 s, total=12.960 s; sync files=27, longest=0.205 s, average=0.009 s; distance=1275 kB, estimate=1275 kB; lsn=0/163D6C0, redo lsn=0/163D688 2024-09-21 15:56:08.871 BST [5853] postgres@simas FATAL: database "simas" does not exist You can see that there are two fatal errors happening. It's not entirely clear whether they are related to the upgrade process or not, because the pg_upgradecluster.OUT file doesn't have timestamps, but I'm assuming they are. I don't understand why the upgrade process did not migrate the "mbm" role to the new cluster. Do you have any customized configuration file(s) for postgresql in your system? I'm wondering if this may be something caused by a local configuration issue. Also, are you able to check if there is a specific log file for the upgrade, please? Maybe under /var/log/? If there is, could you please attach it to this bug as well? Thank you. -- 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
