Sample Header Ad - 728x90

Unable to start posgtresql on AlmaLinux 8.4

0 votes
0 answers
107 views
I’ve been working with the database for over a year, but after rebooting the server I can’t start postgresql:
# sudo systemctl start postgresql
Job for postgresql.service failed because a fatal signal was delivered causing the control process to dump core.
See "systemctl status postgresql.service" and "journalctl -xe" for details.
# sudo systemctl status postgresql
● postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
   Active: failed (Result: core-dump) since Fri 2024-05-24 10:51:52 +03; 44s ago
  Process: 4805 ExecStart=/usr/bin/postmaster -D ${PGDATA} (code=dumped, signal=ILL)
  Process: 4803 ExecStartPre=/usr/libexec/postgresql-check-db-dir postgresql (code=exited, status=0/SUCCESS)
 Main PID: 4805 (code=dumped, signal=ILL)
# journalctl -xe

May 24 10:51:44 hitriy systemd: Starting PostgreSQL database server...
May 24 10:51:52 hitriy systemd: postgresql.service: Main process exited, code=dumped, status=4/ILL
May 24 10:51:52 hitriy systemd: postgresql.service: Failed with result 'core-dump'.
May 24 10:51:52 hitriy systemd: Failed to start PostgreSQL database server.
May 24 10:51:52 hitriy systemd-coredump: Resource limits disable core dumping for process 4805 (postmaster). May 24 10:51:52 hitriy systemd-coredump: Process 4805 (postmaster) of user 26 dumped core. -- Subject: Process 4805 (postmaster) dumped core -- Defined-By: systemd -- Support: https://access.redhat.com/support -- Documentation: man:core(5) -- -- Process 4805 (postmaster) crashed and dumped core. -- -- This usually indicates a programming error in the crashing program and -- should be reported to its vendor as a bug. May 24 10:51:52 hitriy systemd: postgresql.service: Main process exited, code=dumped, status=4/ILL May 24 10:51:52 hitriy systemd: postgresql.service: Failed with result 'core-dump'. -- Subject: Unit failed -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit postgresql.service has entered the 'failed' state with result 'core-dump'. May 24 10:51:52 hitriy systemd: Failed to start PostgreSQL database server. ``` Whats wrong? Please help me!!!
Asked by Hitriy (1 rep)
May 24, 2024, 08:04 AM