Discourse の再構築処理が PostgreSQL 初期化時に「trust」認証警告でハングする

This is a problem.

If you have a recent backup, I’d do a clean install and restore it.

But maybe have a look at PostgreSQL 15 update and see about moving the postgres backup back to postgres_data.