Debugging Failed Startup

From: Ray Cote <rgacote(at)appropriatesolutions(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Debugging Failed Startup
Date: 2019-05-02 18:22:46
Message-ID: CAG5tnzpZcKGeJE7B8c4uNKDcfw-eHT3JuiJAd7A+Jr0CD7_GAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does anyone have a hint on how I'd go about debugging why PostgreSQL 11 is
not starting on CentOS 7?
Was running fine for several weeks then fails to come up after a reboot.

I did change the name of the CentOS7 server, but I don't expect that to
have any effect on the database.

I'm running debug5 to the logs.

There's nothing in the ./log directory past the database shutting down.
Here's what's in messages. All seems to be fine and then boom!

... postmaster: LOG: listening on IPv6 address "::1", port 5432
... postmaster: LOG: listening on IPv4 address "127.0.0.1", port 5432
... postmaster: LOG: listening on Unix socket
"/var/run/postgresql/.s.PGSQL.5432"
... postmaster: LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
... postmaster: DEBUG: invoking IpcMemoryCreate(size=148553728)
... postmaster: DEBUG: SlruScanDirectory invoking callback on
pg_notify/0000
... postmaster: DEBUG: removing file "pg_notify/0000"
... postmaster: DEBUG: dynamic shared memory system will support 288
segments
... postmaster: DEBUG: created dynamic shared memory control segment
1998722972 (6928 bytes)
... postmaster: DEBUG: max_safe_fds = 983, usable_fds = 1000, already_open
= 7
... postmaster: LOG: redirecting log output to logging collector process
... postmaster: HINT: Future log output will appear in directory "log".
... systemd: postgresql-11.service: main process exited, code=exited,
status=1/FAILURE
... systemd: Failed to start PostgreSQL 11 database server.
... systemd: Unit postgresql-11.service entered failed state.

--Ray

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-05-02 18:57:23 Re: Debugging Failed Startup
Previous Message rihad 2019-05-02 17:45:25 Re: Upgrading locale issues