Job for postgresql.service failed because the control process exited with error

$ sudo systemctl start postgresql.service Job for postgresql.service failed because the control process exited with error code. See "systemctl status postgresql.service" and "journalctl -xeu postgresql.service" for details.

$ journalctl -xeu postgresql.service The unit postgresql.service has entered the 'failed' state with result 'exit-code'. янв 03 12:09:05 fedora systemd[1]: Failed to start postgresql.service - PostgreSQL database server. Subject: Ошибка юнита postgresql.service Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel   Произошел сбой юнита postgresql.service. Результат: failed. янв 03 12:11:38 fedora systemd[1]: Starting postgresql.service - PostgreSQL database server... Subject: Начинается запуск юнита postgresql.service Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel Начат процесс запуска юнита postgresql.service. янв 03 12:11:39 fedora postgresql-check-db-dir[5568]: An old version of the database format was found. янв 03 12:11:39 fedora postgresql-check-db-dir[5568]: Use 'postgresql-setup --upgrade' to upgrade to version '16' янв 03 12:11:39 fedora postgresql-check-db-dir[5568]: See /usr/share/doc/postgresql16/README.rpm-dist for more information. янв 03 12:11:39 fedora systemd[1]: postgresql.service: Control process exited, code=exited, status=1/FAILURE Subject: Unit process exited Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel An ExecStartPre= process belonging to unit postgresql.service has exited. The process' exit code is 'exited' and its exit status is 1. янв 03 12:11:39 fedora systemd[1]: postgresql.service: Failed with result 'exit-code'. Subject: Unit failed Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel The unit postgresql.service has entered the 'failed' state with result 'exit-code'. янв 03 12:11:39 fedora systemd[1]: Failed to start postgresql.service - PostgreSQL database server. Subject: Ошибка юнита postgresql.service Defined-By: systemd Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel Произошел сбой юнита postgresql.service. Результат: failed.

An old version of the database format was found.

sudo postgresql-setup --upgrade

$ sudo postgresql-setup --upgrade ERROR: Please install the postgresql-upgrade package.

$ sudo postgresql-setup --upgrade [sudo] пароль для timoty:   * Upgrading database. * Upgraded OK. WARNING: The configuration files were replaced by default configuration. WARNING: The previous configuration and data are stored in folder WARNING: /var/lib/pgsql/data-old. WARNING: If you've just upgraded your database from a previous major version of Fedora or RHEL, please run reindexdb against your databases.  Core library collation data may have changed and this will invalidate database indexes.  For example, in Fedora 28 and RHEL 8 there have been extensive changes in glibc collations to support ISO 14651:2016 (Unicode 9.0.0 data) and your indexes may be affected: https://sourceware.org/ml/libc-announce/2018/msg00002.html * See /var/lib/pgsql/upgrade_postgresql.log for details.

$ sudo service postgresql restart Redirecting to /bin/systemctl restart postgresql.service $ sudo -u postgres psql

postgres=# REINDEX DATABASE postgres; REINDEX

$ sudo -u postgres psql ПРЕДУПРЕЖДЕНИЕ:  несовпадение версии для правила сортировки в базе данных "postgres" ПОДРОБНОСТИ:  База данных была создана с версией правила сортировки 2.38, но операционная система предоставляет версию 2.40. ПОДСКАЗКА:  Перестройте все объекты в этой базе, задействующие основное правило сортировки, и выполните ALTER DATABASE postgr es REFRESH COLLATION VERSION, либо соберите PostgreSQL с правильной версией библиотеки. psql (16.3) Введите "help", чтобы получить справку.